Selecting a printer

[Simon Scholefield]

Hi does anyone have any suggestion on how to select a printer other than the
default when printing an automated report in Access 2000?

Regards

 

[Ken Snell [MVP]]

Check out the Application.Printer object. You can set it to any printer
device that is attached to the PC.

Set Application.Printer = Application.Printers("DeviceName")

 

[Allen Browne]

If you always want to print a report to one of your printers that is not the
default, open the report in design view. Choose Page Setup from the File
menu. On the middle tab, choose Specified Printer. Save the report.

If you are designing for other people, and need to select a printer at
runtime, see Albert Kallal's code at:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

For Access 2002 and later, you can use the Printer object as Ken suggested.
There is an example of how to do that in this article:
http://members.iinet.net.au/~allenbrowne/AppPrintMgt.html