specify printer when printing

[Scott N. Weber]

I have a report that the user runs by clicking a button on a form. I'd like
to give them a combo box listing the available printers that they have and
then send to report to that printer. I remember this was more involved in
Access 2000 but was much easier in 2002. Does anyone have sample code for
2002?

 

[Allen Browne]

See:
Printer Selection Utility
at:
http://members.iinet.net.au/~allenbrowne/AppPrintMgt.html

Downloadable example for Access 2002/2003 gives the user a toolbar button
where they choose the printer the report is to go to. It sets a custom
property for the report. You then use the replacement for OpenReport, and it
sets that as the default printer when the report is opened, and handles
switching the printers even if the user is previewing several reports at
once.

 

[Scott N. Weber]

Thanks dude!!!!!!

 

[Mike Mertes]

Do you think Microsoft could get more popular with the younger crowd if they
started a development program for teens?

"Dude, you're getting an Access Database!"

Just a thought.