Time Delay to Print Report

[Lamar]

The user clicks a button to print the same report over and over again but
different clients. The code is looped. The user is actually printing the
report to Fax Printer to be faxed the different clients.

When the report is printed to the Fax Printer it prompts the user to hit
'OK'. The problem Access is keeping printing the other reports before the
user can hit 'OK'. This is causing problems for the Fax Printer.

So how can I have a 10 second delay between the reports printing? I could
not figure out the TimerInterval. Thanks for any help.

 

[Stuart McCall]

The user clicks a button to print the same report over and over again but
different clients. The code is looped. The user is actually printing the
report to Fax Printer to be faxed the different clients.

When the report is printed to the Fax Printer it prompts the user to hit
'OK'. The problem Access is keeping printing the other reports before the
user can hit 'OK'. This is causing problems for the Fax Printer.

So how can I have a 10 second delay between the reports printing? I could
not figure out the TimerInterval. Thanks for any help.

startTime = Timer
Do While Timer < startTime + 10
DoEvents
Loop

 

[Jack Leach]

http://www.mvps.org/access/api/api0021.htm

Take a look at this Sleep API from mvps.org. You can put this at the end of
your print procedure (or button click) to suspend all code for a specified
amount of time.

hth
--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)