Using computer clock

[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.

 

[Guest]

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

 

[fredg]

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.

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.

 

[gary]

Thank you very much. Sometimes the simple answers are
the best.


Gary.