Reports with Graph

  • Thread starter Thread starter Roberto Madera
  • Start date Start date
R

Roberto Madera

When i change the data used for Microsoft Graph, it
presents the old value in the first page, in the second
page and forth the new value. How i clean automatically
the old value from datasheet.
Thaks a lot for your help.
R. Madera
 
I expect that your graph has a query or SQL statement in the Row Source
property. You might need to add code to the On Format event of the section
containing your graph control:
Me.grphMyGraph.Requery
 
Sr. I have defined Row Source Type (Table/Query) also Row
Source (Table name). I apply your code of
Me.Grapname.Requery. But The problem continue. In the
datasheet of the graph appear the old values. These are
presented in the first page of the reports, in the secon
page the graph contains the correct value (read from table
query). The datasheet from Ms Graph do not update. How I
can update the graph report, once i changed de table/query
values.
I spent days on this, i can't understand how to solve
this, please if you want i can sent the dbm file. To
verify these.
God bless you,
R. Madera
 
R:

Stop by our web site and look at the current tip on Graph in the Code and
Design Tips area. It contains code that will update the data sheet as well
as the graph when its displayed.

HTH
 
Thanks Steve.

--
Duane Hookom
MS Access MVP


SA said:
R:

Stop by our web site and look at the current tip on Graph in the Code and
Design Tips area. It contains code that will update the data sheet as well
as the graph when its displayed.

HTH
Click to expand...
 
I test your code, really are excellent. No imagine your
helping task, was enormous. I spent severals intensive
days. GOD BLESS YOU anywhere you are. Also thanks to Duane
Hookom.
R. Madera
 
Back
Top