printing multiple reports with one print dialog box

  • Thread starter BBC via AccessMonster.com
  • Start date
B

BBC via AccessMonster.com

I have a multi-select list box where the user can chose to print multiple
reports at once. Where do I position the vba code to bring up the print
dialog box to choose printer, etc. I currently loop through the slected
items and DoCmd OpenReport (this works great to the default printer). But I
want to allow printer selection, etc. Do I position the dialog cod after
issuing the first OpenReport or after all have been done (end of the loop).
One concern is that some reports are portrait, some landscape. How will
using the dialog box affect the individual reports default settings, can I
stop them changing that setting or ???

thanks all
 

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

Top