Pause a print job....

I would like to be able to have my program put print jobs on hold in the print queue instead of automatically printing them.

Is their a simple way to "pause" a print job when the report has been generated ?

The reason I need this is because some of my reports require special pre-printed forms to be loaded on the printer. Since this is a requirement I simply need each report as it is being generated to be "paused" until the user releases it to be printed.

Thanks in advance for any help !!!

When I had a report that needed to print on both sides of the paper I printed the first page and then used the Message box to, basically pause the print job until the user turned over the paper in the printer.

Here is the basic code -

Dim Answer as String

Answer = MsgBox "Please turn page over and re-insert into printer",(OK and Cancel button), "Paused Printing"

If Answer = vbOK Then
'Print the page
Else
'Skip the Page
End If

You would need to insert this before you start the print process.

This may help

Have a nice day

I suppose you could use the same idea at the end of the print routine -


If Answer = vbOK then
EndDoc
Else
KillDoc
End If