autorun a specific report

B

Bloggsy

How can I schedule a report to run say every Monday morning without manual
intervention?
 
J

John W. Vinson

How can I schedule a report to run say every Monday morning without manual
intervention?

One way to do so is to create a Macro (one of the few times I use macros
actually!) named RunReport which does two things: runs the report, and closes
Access.

Then use Windows Scheduler to open Access using a command switch to run the
macro: The command line should be something like

"C:\Program Files\yadayada\msaccess.exe" "K:\path\yourdb.mdb" /x RunReport


John W. Vinson [MVP]
 
Top