autorun a specific report

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

Guest

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

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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically run a timed report 2
Outlook Outlook To-Do Bar Not Showing 7-days Appointments 0
Message box on macro 1
Trigger a macro to run on a specific date 5
Running a Query and a Report through a scheduled task 4
Using the DateDiff function based on 5 days 12
How can I print multi page report with 4 pages per sheet? 2
Unbinding all a Reports ControlSources 3

Back
Top