pause printer or open printer window

[Kevin K. Sullivan]

Does anyone know a way to pause the default printer or open the Windows
printer window (which shows the print queue) from VBA?

Thanks,

Kevin

 

[MIkeC]

Kevin,

Below is a quick way to display the printer window. In
this example, I'm assuming you want to print a report.

Dim stDocName As String

stDocName = "YourReport"

DoCmd.SelectObject acReport, stDocName, True
DoCmd.RunCommand acCmdPrint

 

[Kevin K. Sullivan]

Thanks Mike. That code is great to allow the user to change printers,
number of copies, etc.

Actually, what I'm trying to replicate is double-clicking the printer in the
Printers and Faxes folder of the Control Panel.

Does anyone have any ideas?

TIA,

Kevin