Schedule a report to open daily?

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

Guest

I'm always on the machine sometime between 4 AM and 8 AM. I'd like a certain
report to open automatically when I go into my database if I do so within
that time frame. Can this be done?
 
Sue,

You can use a macro assigned on a suitable event, perhaps the Open event
of a form that always opens when the database opens, or some such. The
macro will use the OpenReport action. In the Condition column of the
macro design, put...
Time()>#04:00# And Time()<#08:00#

A potential problem here is that if you close the database and then open
again within that time period, the report will print again. If this is
a likely scenario, and you want to restrict it to once per day, this can
be done using smoke and mirrors.
 
Thanks, Steve.
Perhaps some day in the distant future, I will learn about smoke and mirrors!
 
Back
Top