Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / January 2005

Tip: Looking for answers? Try searching our database.

Linked Access chart sometimes not updating properly

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
CalhounRaccoon - 28 Jan 2005 22:51 GMT
In Access 2002, when printing 50+ graph reports, via macro, several
(different each time) show the original data on the graph, rather than the
live data.

Every report works properly individually, and every report that has failed
has worked before, successfully, without any subsequent design changes.

It just seems a few each run fail to update their data, when later, those
work, while others fail.

I have tried adding a macro step to "requery page" to the "on print" event
of the section of my report containing the linked form, but it doesn't solve
the problem.

Any ideas?  I would greatly appreciate any help!

Thanks!

CalhounRaccoon
CalhounRaccoon - 31 Jan 2005 23:01 GMT
Never mind.

I found Duane's earlier post, helping someone else, and it worked.

FYI, he referred to a string of code including

"objGraph.refresh"

stored in the "on print" event of the report section.

I tried to use a macro to do "refresh page", but that didn't work.  His code
did.  I was trying to stay in the "macro world", avoiding the "code world" as
much as possible.

Thanks, Duane!

Calhoun Raccoon

> In Access 2002, when printing 50+ graph reports, via macro, several
> (different each time) show the original data on the graph, rather than the
[quoted text clipped - 15 lines]
>
> CalhounRaccoon
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.