Automatically producing Report on a daily basis

[Pat Backowski]

Hi Everyone,

Probably a question with a simple answer - I have a customer who is too lazy
to push a button once a day and produce a report. Is there a way to set a
timer on a report (or a form that calls a report) that runs once a day. I've
used timers based on seconds but not to run at 6 a.m. everyday

As always, thanks for your kind assistance
Pat.

 

[krissco]

Hi Everyone,

Probably a question with a simple answer - I have a customer who is too lazy
to push a button once a day and produce a report. Is there a way to set a
timer on a report (or a form that calls a report) that runs once a day. I've
used timers based on seconds but not to run at 6 a.m. everyday

As always, thanks for your kind assistance
Pat.

Pat,

This just came to mind (haven't tested it).

You may be able to do this using a form which is always open.

1. OnOpen - Find the difference in time between Now() and the next
6AM. Store this value in milliseconds as the Timer Interval.
2. OnTimer - Open the report. Set Timer Interval to 86400000 (or
whatever 24hours is in milliseconds).

-Kris