Reports with Graph

[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

 

[Duane Hookom]

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

 

[R. Madera]

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

 

[SA]

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

 

[Duane Hookom]

Thanks Steve.

--
Duane Hookom
MS Access MVP

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

 

[Roberto Madera]

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