beefing up reports and queries

[Guest]

Hi All,

I am using microsoft access reports to generate dynamic report from no of
queries. However, I am looking for a functionality where the piece of VB code
( or something like macros) will run my queries automatically before the
Report is activated hence I can get always updated values dont have to run
queries manually.

Any suggestions?

Thanks

Dhaval

 

[Allen Browne]

Create a macro with the RunSQL action for each action query you need to run.

Or, if you care about whether the actions completed or not, use the Execute
method in code.

Examples and details of the differences in this article:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html