How to Change Default Printer Using Macro Statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paputxi - 30 Aug 2006 21:19 GMT

Does anyone know if and how I can change my printer using an Access Macro
statement? Not using a Macro, I presently have to manually do this each time
I generate a report and then select the printer I want when I Print the
report. I'm actually outputting to a PDF file and I have full Acrobat on my
computer. So I am able to manually do this. However, I'd like to automate
this process by temporarily assigning the PDF printer via a Macro statement
rather than having to manually do it each time.

Thanks in advance.

Reply to this Message

Douglas J. Steele - 30 Aug 2006 22:02 GMT

I don't think you can do it using a macro, but you certainly can using VBA.

Albert Kallal has an example at
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Does anyone know if and how I can change my printer using an Access Macro
> statement? Not using a Macro, I presently have to manually do this each
[quoted text clipped - 9 lines]
>
> Thanks in advance.

Reply to this Message