Report Printing

[dbl]

Hi how do I send a report to a non default printer by using a command button?

I want to set up command buttons to send reports to different printers rather
that using file print and then choosing the printer.

Is this possible and if it is how do I go about it?

Thanks Bob

 

[Allen Browne]

In Access 2002 and 2003, you can set the Application.Printer to send the
report to a printer at runtime.

If you are using these versions, and would like the report to remember the
printer that the user wants to use for that report, see:
Printer Selection Utility
at:
http://members.iinet.net.au/~allenbrowne/AppPrintMgt.html

The article has links for utilities that work with older versions also.