Using computer clock

  • Thread starter Thread starter gary
  • Start date Start date
G

gary

I want a report to print out at 5:00 p.m. everyday. How
do I automate this to happen the same time everyday?

Thanks,

Gary.
 
Hi Gary,

Did you try the Windows Scheduler?
You can use it if the Access db is not open at that time.

If you want more info, try searching for 'schedule' in the newsgroup.

Regards,
Bernd
 
I want a report to print out at 5:00 p.m. everyday. How
do I automate this to happen the same time everyday?

Thanks,

Gary.
Click to expand...

If you are able to have a form open (hidden is OK) at least just
before that time ...

Set the Form's Timer Interval to 1000

Code the Form's Timer event:
If Time = #05:00:00 PM# Then
DoCmd.Open Report "ReportName"

Otherwise, use the Windows Scheduler program.
 
Back
Top