Coding a "Select Printer" command

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello. It has been a while.

I have a report that is based on a query. On the query form, I have created
a "print report" radio button. This report prints fine, except that it is set
to print to the default printer. I would like to program a command that opens
the printer dialogue box which will allow the user to select any printer that
has been set up. Can someone provide some guidance as to how I can do this?
 
After you OpenReport in preview, you could open the print dialog with:
RunCommand acCmdPrint

If you always want the report to go to the same printer, and you have this
printer connected, you can open the report in design view, and choose Page
Setup on the File menu. On the 2nd tab of the dialog you can specify to use
a particular printer.

If you want the user to be able to choose one of their printers (which you
don't have on your development machine) and have the report default to that
printer again next time, see:
Printer Selection Utility
at:
http://allenbrowne.com/AppPrintMgt.html
The downloadable example for Access 2002/2003 also demonstrates how to use a
toolbar button to let the user choose the printer for the report.
 
Back
Top