printing options for reports

[Stinky Pete]

Hi,

I've been reading, and successfully tested some code referred to in
this group, that allows a user to select a printer before printing a
report. The code has worked well on single page reports, however I
want to expand the logic and I'm getting lost.

I've got a form that needs to be printed via multiple reports which
print with the DoCmd.OpenReport option as they print one after the
other. However, due to the number of pages, someone suggested I print
them double sided. Good idea. However how do I get the user to chosse
a printer (once and not for each separate report) and also allow the
user to select the options to print double sided if possible.
Typically, being on a network not everyone is using the same printer,
nor are they all duplex.

Hope that makes sense,

Stinky Pete ;-)

[victorcamp]

I've noticed that the Print command on the File menu is not the same as the
OpenReport method. If you execute the Print command on the File menu instead
(via code), you should get the standard Windows print dialog box, allowing
the user to choose the printer, as well as access to printing options.
"Stinky Pete" <Pe**********@symbionhealth.comwrote in message
news:11**********************@e3g2000cwe.googlegro ups.com...

Hi,

I've been reading, and successfully tested some code referred to in
this group, that allows a user to select a printer before printing a
report. The code has worked well on single page reports, however I
want to expand the logic and I'm getting lost.

I've got a form that needs to be printed via multiple reports which
print with the DoCmd.OpenReport option as they print one after the
other. However, due to the number of pages, someone suggested I print
them double sided. Good idea. However how do I get the user to chosse
a printer (once and not for each separate report) and also allow the
user to select the options to print double sided if possible.
Typically, being on a network not everyone is using the same printer,
nor are they all duplex.

Hope that makes sense,

Stinky Pete ;-)