Change destination printer



I need to send stickers to a specific printer (several in factory, all same)
based on the workstation requesting. I need to compose the report to "use
specific printer" to get margins etc correct, but having done that the usual
trick of altering the default printer is ignored when I try to send it to the
desired printer. Is there any way to programatically alter the saved
"specifc printer"?
Thanks in advance.


if you are using Access 2002 or later, there is a property of the
report you can alter:

Set Application.Printer = Application.Printers("HP LaserJet Series

you probably want to look at the default printer first, store that
name and switch back to it when you are done:

dim defPrinter as string

defPrinter = Application.Printer.DeviceName

Set Application.Printer = Application.Printers("HP LaserJet Series

*Run Report, or whatever

Set Application.Printer = Application.Printers(defPrinter)

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question