Printing Reports

[Antonio]

I have a report that needs to be printed on two types of paper. The user
clicks on a Print Button located on a form that pulls the report based on a
query that gets its parameter information from unbound text boxes on the same
form. Is it possible to specify what printer prints the report in an access
database?
ie...this button, when clicked, prints the report on printer A (which is
loaded with the 90 lb card stock)
this button, when clicked, prints the report on printer B (loaded with
regular paper)
Outside of changing the default printer each time or opening the report in
Design view and then selecting the printer...any suggestions to
progromattically perform this task?
TIA
Antonio

 

[Wayne-I-M]

Hi Antonio

You need to create a small module and then call this module from you print
button that you create on the form.

It quite simple as you can copy and paste the module and codes from this
link this

http://support.microsoft.com/kb/319317/en-us

Good luck

 

[Tom Wickerath]

To add a little to Wayne's answer, one caveat to keep in mind is that you
cannot use the compiled .mde form when implementing the code shown in the KB
article, since it depends on opening the report in design view.

Access MVP Allen Browne offers a nice version that does work with .mde files:

Printer Selection Utility
http://allenbrowne.com/AppPrintMgt.html


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[strive4peace]

Hi Tom,

thanks! great reference!

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*