Access to Print a Document while Its not Running(Access switched off)

[Mapprog]

Hi

I would appreciate some help on making my access program to print a page when the due date is reached.Problem is access might be shwitched off on the due date so the progro\am should print not considering the access status( on / off)

Using Access 2007, I put this code in a macro in the close event of the form(Date()>=[Forms]![Assets Overdue Frm]![return date])

hoping the coe would run in the backround and do the job, to no success.

Can anybody help.

Mapprog

 

[Gammachaser]

Use Windows Task Scheduler to start the program every day at a specified time and use an Autoexec Macro (or a Startup Form) to run the code to check if the due date has arrived and, if so, print the document. After printing (or if the due date has not been met) close the application.