Issues with graphs in report

[Guest]

We have been having problems with graphs refreshing properly in access
reports. Previously we have deleted all data out of the data tables in the
graph design view so that when the report was run in print preview it was
immediatley obvious when a graph had not refreshed as it was blank. However,
this now appears not to work as once a report is run - the graphs in design
view now have data displayed in them. We have added some VBA code ;

On Error Resume Next
Dim objGraph1 As Object
Set objGraph = Me!Graph80.Object
objGraph.Refresh
objGraph.Application.Update
DoEvents
Set objGraph = Nothing

We added the VBA code to force the graphs to refresh but is there any way -
we can keep the graphs blank in design view so that we can instantly tell if
they have not refreshed?

Any help will be gratefully recieved. PLEASE HELP US!!

 

[Rick Brandt]

We have been having problems with graphs refreshing properly in access
reports. Previously we have deleted all data out of the data tables
in the graph design view so that when the report was run in print
preview it was immediatley obvious when a graph had not refreshed as
it was blank. However, this now appears not to work as once a report
is run - the graphs in design view now have data displayed in them.
We have added some VBA code ;

On Error Resume Next
Dim objGraph1 As Object
Set objGraph = Me!Graph80.Object
objGraph.Refresh
objGraph.Application.Update
DoEvents
Set objGraph = Nothing

We added the VBA code to force the graphs to refresh but is there any
way - we can keep the graphs blank in design view so that we can
instantly tell if they have not refreshed?

Any help will be gratefully recieved. PLEASE HELP US!!

Cut and paste your chart into a form and make it Enabled=Yes and Locked=No.
Then modify the query it uses to temporarily return zero rows. Open the form
and make sure you see a blank chart. Then (while the form is opened)
double-click the chart to bring up the chart designer. One difference when
using a form is that you don't have to be in design view to do this.

The chart should still be blank in the designer. Close the designer by clicking
elsewhere on the form and then press Save. Return to design view and
double-click the chart to verify that it is still blank in the designer. If it
is then close the designer and then cut and past the chart back to your report.
Finally, change the query back to the way it was originally.

You should see that the chart in the report is now blank when looked at in the
designer.