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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macOS Office365 Word 0
printing multiple reports with one print dialog box 0
Insert Multiple Fields without Dialog closing between each... 0
Upgraded from Win 7 to Win 10. Publisher printing black. 1
Word docs emailed to me are opening blank (greyed screen) in Print Mode 0
Active Content in this file is blocked issue 1
Button to print several reports 6
Changing defaults in the Print Dialog 0

Top