Printing To Specific Printers

[TK]

Does anyone know if I can hard code a report to print to a specific printer?
What I want to be able to do is have two buttons on a form. If a user
selects Button 1 then a list of reports will appear and whichever report the
user chooses will print on Printer #1. If user selects Button 2, then the
reports that the user chooses will send the reports to Printer #2.

Thanks for any help or suggestions from anyone.

T

 

[Allen Browne]

If you are using Access 2002 or 2003, this is very easy. You can just set
the Printer before you OpenReport, e.g.:
Set Printer = Printers(0)

It is more involved for earlier versions.
Here's an example database for Access 2000:
http://www.members.shaw.ca/AlbertKallal/msaccess/printch2k.zip
or Access 97:
http://www.members.shaw.ca/AlbertKallal/msaccess/printch97.zip

This article has a sample for Access 2002/3 that uses the Printer object:
http://allenbrowne.com/AppPrintMgt.html