Printer selection

V

Very Basic User

Hello,

I have a command button that currently prints a list of several reports...
My current code is copied below. This is fully auto sending the print job to
your default printer. Instead of going to default, I just want to open the
"print" box where teh user can change printers or cancel before they start
printing if they want. Is there any addition to this code that would open the
print options versus auto sending it to default printer?

Private Sub Command84_Click()
On Error GoTo Err_Command84_Click
DoCmd.OpenReport "A_Back Processing Game Plan Report", acNormal
DoCmd.OpenReport "A_Bag packaging Game Plan Report", acNormal
DoCmd.OpenReport "A_Box semi auto Game Plan Report", acNormal
DoCmd.OpenReport "A_Building and Grounds Game Plan Report", acNormal
DoCmd.OpenReport "A_Front Processing Game Plan Report", acNormal
DoCmd.OpenReport "A_lab Game Plan Report", acNormal
DoCmd.OpenReport "A_Print Weigh Game Plan Report", acNormal
DoCmd.OpenReport "A_Sanitation Game Plan Report", acNormal
DoCmd.OpenReport "A_Shipping / Receiving Game Plan Report", acNormal
DoCmd.OpenReport "A_Warehousing Game Plan Report", acNormal
DoCmd.OpenReport "Bulk Game Plan Report", acNormal
Exit_Command84_Click:
Exit Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select printer 1
View & Print Report from Form's Command Button using Lexmark Printer 1
I want print button to print to default printer depending on user 1
Printer Dialog 4
Access Change My Default Printer 1
Access change My Default Printer for All the Reports 4
Print Button Code 2
Help!! 3

Top