Automatically Print Report Based upon System Date/Time?

[Don & Elena]

Thanks in advance for any insight.........

Is there a module or code that can be written which will
allow us to automatically print an Access Report based
upon the system's date/time? (i.e. print automatically
every morning at 1am, or whatever).

We prefer NOT to have the database open all the time, but
if the code is easier to write with the database always
open, we would be willing to do so. The report is always
run at a specific printer.

Is there an event we can write? We are thinking of some
sort of IF statement that checks the systems date & time.

Thanks Again,
Elena & Don

 

[Phil Hunt]

try:
create a short cut to the report by right click on the report
go to task manager/schedule task and create a task to run at the time you
want. then navigate to set the program to the shortcut.

There may be other way to do this. But this one seems easy and fun to do.

 

[SteveD]

I have done this ..... Here's the concept.

Using the windows task scheduler, create a task that opens
Access and a specific database (like when you create an
icon that opens a specific database). When this database
opens and your opening form, use the onOpen event (or
timer event), call a module that will prints the report
and then quit your applciation.

Mine runs at 6:30am it runs a specific report.

I think this is what your after.

SteveD
PS: this may sound complicated, but if taken in small
steps, it's not.