Allow user to select printer

[Chris Patton]

Hi,
Is there some code I can use that will allow the user to select a printer
before printing a report? I'd appreciate any help anyone can offer.
Thanks,
Chris

 

[Immanuel Sibero]

Hi,

To use code to control printers, check out this site:
http://www.mvps.org/access/reports/rpt0009.htm

Alternatively, depending on how receptive your users are, you could simply
code all your reports with Preview option. While the reports are previewed,
the users can decide if they want to print or cancel; if they decide they
want to print, they can choose/change printer.

HTH
Immanuel Sibero

 

[SA]

Chris:

You might want to stop by our web and look at our "On the Fly Printing" code
/ class modules. These will allow you to give the user a Print Dialog
(either standard Windows or a custom one) that allows them to pick the
printer to use before sending a report to print.