Choosing a printer from a form

[Bob 4]

I have a reservation system that generates invoices. We send some to a
specific printer tray and others we print to PDF. Right now I have 2
versions of the invoice report (one for each printer). How can I use just
one invoice report and specify the printer programmatically in VBA?

Much appreciated. bob

 

[robert.waters]

I have a reservation system that generates invoices. We send some to a
specific printer tray and others we print to PDF. Right now I have 2
versions of the invoice report (one for each printer). How can I use just
one invoice report and specify the printer programmatically in VBA?

Much appreciated. bob

Set Application.Printer = Application.printers("printer name")

 

[Albert D. Kallal]

You don't mention what version of ms-access.

for a2002 and later, there is a printer object...

and, for PDF creating, don't use a PDF printer, use Lebans solution here:

http://www.lebans.com/reporttopdf.htm

the above allows you to create pdf, and you do not have to switch
printers..or even install a pdf printer. Like wow...does Lebans solution
solve deployment issues or what!!!