By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,476 Members | 1,497 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,476 IT Pros & Developers. It's quick & easy.

MSGraph Display Issue in A97 under WinXP

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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!MyChartControlName
objGraph.Refresh
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

P: n/a
"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!MyChartControlName
objGraph.Refresh
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(Cancel As Integer, FormatCount As Integer)
If FormatCount = 1 Then
'...may want your own code here to create/modify the appropriate
datasource...
Graph1.Object.Application.Update
Graph1.Object.Application.Chart.Refresh
Graph1.Requery
End If
Exit Sub

Hope it helps someone

Dom
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.