473,725 Members | 2,360 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

MSGraph Display Issue in A97 under WinXP

We have an application that outputs several different graphs from data
downloaded from our AS400. The application has worked without (this)
issue for several months now, but just recently, the workstation it is
normally run from has been upgraded to WinXP from WinNT 5.0.

The issue is that the graphs will either display the data within the
recordsource (a query), OR it will display the "temp" data in the
chart's datasheet (from initial formatting) on a random basis.
Toggles between print preview and design view can repeat the issue.
Again, it's random - almost purely 50/50. When the application is run
again on a WinNT machine, the issue does not occur, and the graph
accurately represents the underlying recordset without fail.

As our company (finally) is upgrading the WinNT workstations, this
will become an increasing issue. Does anyone have any idea the cause.
(And please, no A97 bashing here. I don't have control over that.)

Thanks,
Anthony.
Nov 12 '05 #1
2 2463
Hi,

normally nobody here does bash one of the most stable Access versions ever <g>
(I bash the versions in between, specially 95 and 2000, because they are crap,
but never 97...)

and now to your question ...
AFAC it´s a timing issue

To force Graph to have the freshest data, add this code to the OnPrint
section of the report that contains the Graph object

Dim objGraph as object
Set objGraph = Me!MyChartContr olName
objGraph.Refres h
Set objGraph = Nothing

This should help

--
mfg

Klaus Oberdalhoff [MVP]
Anthony Cuttitta Jr. wrote:
We have an application that outputs several different graphs from data
downloaded from our AS400. The application has worked without (this)
issue for several months now, but just recently, the workstation it is
normally run from has been upgraded to WinXP from WinNT 5.0.

The issue is that the graphs will either display the data within the
recordsource (a query), OR it will display the "temp" data in the
chart's datasheet (from initial formatting) on a random basis.
Toggles between print preview and design view can repeat the issue.
Again, it's random - almost purely 50/50. When the application is run
again on a WinNT machine, the issue does not occur, and the graph
accurately represents the underlying recordset without fail.

As our company (finally) is upgrading the WinNT workstations, this
will become an increasing issue. Does anyone have any idea the cause.
(And please, no A97 bashing here. I don't have control over that.)

Thanks,
Anthony.


Nov 12 '05 #2
"Klaus Oberdalhoff [MVP]" <ko**@gmx.de> wrote in message news:<bt******* ******@news.t-online.com>...
Hi,

normally nobody here does bash one of the most stable Access versions ever <g>
(I bash the versions in between, specially 95 and 2000, because they are crap,
but never 97...)

and now to your question ...
AFAC it´s a timing issue

To force Graph to have the freshest data, add this code to the OnPrint
section of the report that contains the Graph object

Dim objGraph as object
Set objGraph = Me!MyChartContr olName
objGraph.Refres h
Set objGraph = Nothing

This should help


Klaus: Thanks for your help, however, this didn't work for us as the
issue still occurred.

The following did end up working 100% of the time. Same principle as
you're using, but deeper into the graph object. I thought I'd include
it so the next dev with the issue doesn't have to dig too.

Thanks again,
Anthony.

This is what another member of my team found on dbforums.com:

http://dbforums.com/arch/201/2002/12/612783 (look for article by
"Dom")

I think the neatest solution to this Windows 2000/XP Graph 8.0 /Access
97 problem is shown below (where the Chart object is called 'Graph1').
This works for multiple graphs on a single page (as it should). No
need for subreports...

Private Sub Detail_Format(C ancel As Integer, FormatCount As Integer)
If FormatCount = 1 Then
'...may want your own code here to create/modify the appropriate
datasource...
Graph1.Object.A pplication.Upda te
Graph1.Object.A pplication.Char t.Refresh
Graph1.Requery
End If
Exit Sub

Hope it helps someone

Dom
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
5837
by: badbetty | last post by:
Dear Googlers I have installed PHP5 to run on WinXP against Apache 2. It works! ie. I have tested a few simple scripts and a basic xml document parse. I now want to try the XSL extension so I can transform xml docs. Having copied the php_xsl.dll to a directory where it can be found and done the uncommenting in php.ini, it still will not work. The script I
0
1965
by: DK | last post by:
I have 3 table A, B, C. I have shown sample data in the tables below: Table A: Tabel A: This table represents the fields in a form. Each field can have 1 or more options. So in this case field 1 has 2 options – 1 & 2. Where as field 5 has no options – ie it may be a text field. FldId Field Option 1 1 1 2 1 2
1
3431
by: Dominic via DotNetMonster.com | last post by:
With a little help from someone in this forum, I am currently creating forms and then embedding them into tabpages, so that I get a display similar to Lotus Notes. I have one container window, so I am using this approach as an alternative to a MDI container. My issue is that when I resize the container form, the controls that anchored to the right in the embedded form do not move with the container form. After investigating I have found...
1
1525
by: Dominic via DotNetMonster.com | last post by:
With a little help from someone in this forum, I am currently creating forms and then embedding them into tabpages, so that I get a display similar to Lotus Notes. I have one container window, so I am using this approach as an alternative to a MDI container. My issue is that when I resize the container form, the controls that anchored to the right in the embedded form do not move with the container form. After investigating I have found...
1
9033
by: RonY | last post by:
I have a dropdown which calls SetTimePeriod method on change the selection. In the JS function, I reset the field style.display based on what the selection is. This works fine with IE but not working with Firefox browser. The firefox browser has problem to display a field after its style.display is reset. At the end of the JS function, I printed out the fields style.display value. They are set correctly. How to resovle this? My JS is : ...
5
1485
by: David Thielen | last post by:
Hi; Ok, I will be the first to agree that this should be impossible - except we are able to keep repeating it. Our login page - which has moderately complex html and uses <LayoutTemplate> to get the look we want - looks exactly right when running on IIS. But when I run from VS 2005 using the integrated web server, it looks very different - background color in a div is gone, it's in the upper left of the
3
3931
by: ApexData | last post by:
I am using a continuous form for display purposes. Above this form, a single record is displayed so that when the user presses my NewButton they can enter a NewRecord which gets added to the continuous form that displays below. Under the NewButton I have these lines of code: Me.AllowAdditions = True DoCmd.GoToRecord , , acNewRec
1
1419
by: Tim in Phoenix | last post by:
Hello all, I have a problem with two co-existing js files. One is used to render a flash piece using proper HTML syntax, and the other to mitigate an issue in IE6 where .png graphics are not displayed properly (they do not show as transparent and are instead displayed within a non-transparent box.) http://www.avalonphoenixgroup.com/mm5/merchant.mvc?Screen=PNGFLASH This page displays as expected in Mozilla & IE7 and also passes HTML
0
1423
by: PenCraft | last post by:
Never mind. There was a stray comment tag inbetween the CSS code and the body code. I am working on a web page with a background image. I tried using the CSS background tag to avoid the slice and dice table approach. This is the page: http://www.pencraftco.com/slvrec/index.htm It works just fine in Flock 1.2.4 In IE6, the only thing that shows up on the page is the background image. Everything else is gone. If I delete the CSS...
0
9248
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9164
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8072
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6695
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6000
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4506
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4775
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2622
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2151
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.