Automating Report(s)

[Charles L. Phillips]

Hello,
How do I get a report or a group of reports to run at a certain time of day,
on a specific day of the month & print accordingly automatically???

Any ideas or code????

 

[Larry Linson]

Provided the database is open and running (e.g., not tied up with an
unresponded MsgBox or something), you can put a timer on a Form (which
doesn't have to be visible) and leave that form open, and check if the
proper time has come in the timer event, then run the reports with
DoCmd.OpenReport.

But, perhaps better, you could use an outside scheduling program to run a
copy of the database -- one that does nothing but run the desired reports.
That would save you some compute power.

Larry Linson
Microsoft Access MVP