Assign Printer Driver

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

I am using Access 2007 and I know about the problem with printer drivers.
What I'd like to know is this: Can I create an Option Group and assign two
buttons-one for the default printer and one for another printer driver?

If so, can I be directed towards an example of the code behind the Option
Group? Thanks in advance.
 
In Access 2002 and later, you can assign the Printer object, and Access will
print to that rather than the default printer. For example:
Set Printer = Printers(1)
Use the DeviceName to specify a particular printer.
To reset to the default Windows printer again:
Set Printer = Nothing

Here's an example utility you can download, and copy into your database:
Printer Selection Utility
at:
http://allenbrowne.com/AppPrintMgt.html
This has quite a bit more code than you asked for. It provides a toolbar
button that opens a combo where the user can select which printer they want
to use for this report. The database then remembers to use that printer
again next time they open that report.
 
Back
Top