AutoPrint at a certain Time?

[sdzc]

Is it possible to have a report automatically print at a certain time of day without any user prompting?

I would like a report to print every day at 4:00 pm.

 

[pbaldy]

The two basic techniques are using the timer event of a form and Windows Scheduled Tasks. I would use the second for this. Make a db that prints out your report when it opens and then closes itself. You can use an autoexec macro. Then, just call that db from Scheduled Tasks.

 

[GaryPanic]

should do - but you need to use macros and also what time will it fire off from - if the d/b is split F/E B/E with multi users - then you only want it to fire off once so you will need some way of stopping the report fireing off all the f/end users so its just a 1 time jobbie .

macros are not my thing - you might need to repost this in macros to get one of the clever guys to chip in ..

regards

 

[GaryPanic]

Paul - has answered this --
posted at the same time ...

 

[sdzc]

The two basic techniques are using the timer event of a form and Windows Scheduled Tasks. I would use the second for this. Make a db that prints out your report when it opens and then closes itself. You can use an autoexec macro. Then, just call that db from Scheduled Tasks.

Thank you for the response, however, can you elaborate on how another database would be able to link to the report in the main database?

Thanks again

 

[pbaldy]

I would either copy the main database and delete unnecessary objects or export the necessary objects to a new blank database.

 

[sdzc]

The problem with making a copy is that the data that will fill the report can potentially change each day. Any thoughts around that?

 

[pbaldy]

Link to the main database tables. I assumed it was already split, which it probably should be anyway:

http://allenbrowne.com/ser-01.html

 

[sdzc]

OK, I have it to the point where I can run the report from the secondary database.

Can I get some help on how to have the db print the report when it opens and then close itself?

 

[pbaldy]

The simplest would be an autoexec macro. Create a macro with 2 actions, OpenReport (with the Print view) and Quit. Name that macro autoexec and it will run automatically when the database opens. It should print the specified report and then quit.