Open Print Dialog Box in VBA

  • Thread starter Thread starter Katrina
  • Start date Start date
K

Katrina

I want to set up a button to print a report (actually
print about 10 reports at once). I would like the print
dialog box to open up, so that I can pick the printer.
Right now, it just prints to the default printer. Does
anyone have any hints on how to bring up the dialog box?

Will this work for printing multiple reports at once?

Thanks
 
Try
DoCmd.OpenReport "rptToBePrinted", acViewPreview
DoCmd.RunCommand acCmdPrint
This has worked for me
 
Katrina:

Stop by our web and look at our "On the Fly Printing" code. With it you can
pop the print dialog once, then apply that printer selection to any number
of subsequently printed reports simply by setting the FirstSpoolReport flag
to false, after selecting the printer for the first report.
 
Back
Top