Schedule a report to open daily?

[NC_Sue]

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?

 

[Steve Schapel]

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.

 

[NC_Sue]

Thanks, Steve.
Perhaps some day in the distant future, I will learn about smoke and mirrors!