access 2010 vba - outputing a report to multiple pdf's Can the printing Dialog box be supressed

Question

I have a report  that is 1700 pages or more. It produces a front page and back page for each of the 170 names in the query.

It has a subreport for each Student that could vary from 1 to 17 pages.

I can output this report to a single PDF.

I have created a loop that opens the filtered report for each student and outputs a single pdf in its new or existing folder.

This all works well but whilst the loop is running,  for each report to PDF there is a 'Printing' to Dialog box appearing momentarily.

This flashes 170 times during the process.

I am using the docmd's below  

                DoCmd.OpenReport "rptreportsmain", acViewPreview, , "(tblstudents.studentid) ='" & strStudent & "'", acHidden

                DoCmd.OutputTo acOutputReport, "rptreportsmain", acFormatPDF, strFileName, 0  

Is there a way of supressing this printing dialog box whilst the loop is running.

Answer 1

Dirk

Thanks for the help.

Think I will have to leave it there.

Bruce