beefing up reports and queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top