pause printer or open printer window

  • Thread starter Thread starter Kevin K. Sullivan
  • Start date Start date
K

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
 
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
 
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
 
Back
Top