Inconsistent Graph display.

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

Hello,

Thanks Basil for your earlier help.

My Microsoft Graph 2000 Chart will display but the graph
is frequently incorrect as I page through the display.
Many times the Graph is empty even though I have the data
there to support it. Sometimes I can scroll back and forth
with the same data yet get a different graph result.

I'm choosing my data from a static table that never
changes.

When I look at the properties, what should the class be
set to?

Any ideas as to whats wrong? I'd really appreciate any
assistance.

Thanks in advance,

Andy
PS. This problem only occurs in Windows 2000. NT seems
fine.
 
Hello Duane,
I tried the suggestions on site but got the same results.
by about the 3rd page the graph data is empty when there
should be values.

This is the code snippet for my group_header.

On Error Resume Next
Dim objGraph As Object
Set objGraph = Me!Chart1.Object
objGraph.Refresh
'This will update the data sheet
objGraph.Application.Update
DoEvents
Set objGraph = Nothing

What does DoEvents do?
 
Have you definitely got the code in the Print event of the group header? (you don't want the format event which is generally the default that appears

The DoEvents basically takes a breather in the code and lets Windows see if any actions are waiting - eg if you open a form in the middle of a big procedure the screen may not show the form's contents (often just a blank box where the form is) - the DoEvents would go back to Windows which would then refresh the screen view. The MVPs can probably give a much better description of what I'm on about

From my (to be honest quite limited) experience, if the data of the graphs and report is good and the child/parent links are all good, then following the steps on the ACG Soft website should do the trick

Basi

----- (e-mail address removed) wrote: ----

Hello Duane
I tried the suggestions on site but got the same results.
by about the 3rd page the graph data is empty when there
should be values

This is the code snippet for my group_header

On Error Resume Nex
Dim objGraph As Objec
Set objGraph = Me!Chart1.Objec
objGraph.Refres
'This will update the data shee
objGraph.Application.Updat
DoEvent
Set objGraph = Nothin

What does DoEvents do
-----Original Message----
Check ACG's web site for some tips and fixes of graphs on report
http://ourworld.compuserve.com/homepages/attac-cg/
--
Click to expand...
Duane Hooko
MS Access MV
Click to expand...
 
Hello again Basil!

Thanks for your advice so far.

I've changed the code paragraph from GroupHeader0_format
to GroupHeader0_Print (See below), and I'm still getting
the same inconsistent graph results. I'm using Access 2000
on a Windows 2000 laptop.
Is it possible for me to send you (or another MVP) the
MDB? I'm at my wits end. The same code worked in Access 97
and also works in Access 2000 on an NT box. It prints fine
but the screen display is giving empty graphs where data
exists.

Private Sub GroupHeader0_Print(Cancel As Integer,
FormatCount As Integer)
On Error Resume Next
Dim objGraph As Object
Set objGraph = Me!Chart1.Object
objGraph.Refresh
'This will update the data sheet
objGraph.Application.Update
DoEvents
Set objGraph = Nothing
End Sub

Thanks in advance!

Andy
-----Original Message-----
Have you definitely got the code in the Print event of
Click to expand...
the group header? (you don't want the format event which
is generally the default that appears)
The DoEvents basically takes a breather in the code and
Click to expand...
lets Windows see if any actions are waiting - eg if you
open a form in the middle of a big procedure the screen
may not show the form's contents (often just a blank box
where the form is) - the DoEvents would go back to Windows
which would then refresh the screen view. The MVPs can
probably give a much better description of what I'm on
about!
From my (to be honest quite limited) experience, if the
Click to expand...
data of the graphs and report is good and the child/parent
links are all good, then following the steps on the ACG
Soft website should do the trick.
 
So, your graph is located in the Group Header section? I usually try
objGraph.Requery
rather than Refresh.
 
Hi Duane!

Thanks for your response!

I tried using objgraph.Requery with the same inconsistent
results.

Is it possible to get you the MDB?. I have a static table
that I'm using and can strip out extraneous information.
The code itself is very small, but its driving me crazy!

I'm using Access 2000 on a Windows 2000 laptop.
 
Duane!,

I found the problem!...My Code was referring to
GroupHeader0 when it should have been referring to
GroupHeader3.

I really do appreciate your assistance in this!

Andy


Private Sub GroupHeader3_Print(Cancel As Integer,
FormatCount As Integer)
On Error Resume Next
Dim objGraph As Object
Set objGraph = Me!Chart1.Object
objGraph.Requery
'This will update the data sheet
objGraph.Application.Update
DoEvents
Set objGraph = Nothing
End Sub
 
You found the problem? It didn't have anything to do with me asking you
twice about which section the graph was located in ;-)
 
Back
Top