Print Button that first prompts for printer

[Don]

Hello, I have an Access 2003 application that I deploy as a mde file. I'm
using the access runtime for deploying to my users machines. Once you have
a report open in preview mode how do you print it to first get the print
dialog to display to pick a different printer than your default?

I tried creating a custom toolbar and dragging the print icon onto it but
this just directly prints to the default printer and doesn't give you the
option to change.

Thanks

Don

 

[Van T. Dinh]

Don't use the Print Icon of the Preview Toolbar.

Use the Menu Item "Print ..." from the File Menu of the Standard MenuBar.

If you want to use code to create your own custom icon, the VBA statement
you need is:

DoCmd.RunCommand acCmdPrint

(which is equivalent to the Menu Item "Print ...")

 

[Allen Browne]

Don, Van has already given you a good answer to the question you asked.

If you want a toolbar button so the user can select one of *their* printers,
and have the report remember to default to that printer next time the user
runs that report, see:
Printer Selection Utility
at:
http://allenbrowne.com/AppPrintMgt.html

The article includes a sample database that shows how it works.

 

[Don]

Thanks for the help, I went with the custom icon.

Don

 

[Van T. Dinh]

You're welcome ...

When you have time, try Allen's method which is quite good ...