Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

Mapprog

Programmer
Mar 22, 2012
1
ZA
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
 

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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top