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