Open Print Dialog Box in VBA

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
 
T

Tom

Try
DoCmd.OpenReport "rptToBePrinted", acViewPreview
DoCmd.RunCommand acCmdPrint
This has worked for me
 
S

SA

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