By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,118 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

printing options for reports

P: n/a
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 ;-)

Sep 14 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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 ;-)

Sep 14 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.