Setting Printer when Printing Report

[russ1985]

I want 1 button to print about 10-20 reports on 1 click.

I have placed VBA on the button to open each report, print then close.

DoCmd.OpenReport "maintenancepayments", acViewPreview, "", "", acNormal
    DoCmd.RunCommand acCmdPrint
    DoCmd.Close

The problem I have is that each report opens the print dialogue box asking which printer to print to.

Does anyone know a way to stop this happening and get all to print to a specific or default printer.

I have tried setting page options on the report to select default printer but it still shows the print dialogue box.

 

[DCrake]

Why are you printing 10/20 reports consecutively? Is it by chance one for every person? if so if you set a group by clause in your report and tell the report to start a new page after every grooup footer you will get one page per person.

 

[russ1985]

Thanks for the reply.

They are actually 10-20 separate reports. in my code I have only put 1 but this would be repeated for each report name.

 

[DCrake]

You could put all 20 reports into one report as sub reports and print the main report

 

[crmarrio]

Change the acViewPreview argument to acPrint (I think!)