469,920 Members | 2,388 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,920 developers. It's quick & easy.

printing options for reports

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
1 2171
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.

Similar topics

2 posts views Thread by Dave | last post: by
3 posts views Thread by carlor | last post: by
1 post views Thread by Dreamtime | last post: by
5 posts views Thread by sulemanzia | last post: by
reply views Thread by Andy Baker | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.