Rather than sending the report to a virtual printer, you can use the OutputTo method of the DoCmd object to output the report as a PDF file. You'll find an example in InvoicePDF.zip in my public databases folder at:
https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169
Note that if you are using an earlier version of Access you might find that the colour of some form objects such as buttons shows incorrectly and you will need to amend the form design accordingly.
If you have difficulty opening the link, copy the link (NB, not the link location) and paste it into your browser's address bar.
This little demo file includes an option to create multiple PDF files. In my case separate invoices are selected from a multi-select list box, and the code loops through the list box's ItemsSelected collection and build the path by which to save the file.
It also opens the files. In your case you'd simply loop from 1 to
n and remove the last two arguments from the line in my demo, so that it simply prompts for a file name each time and creates each file invisibly; so the line of code would be
like this:
DoCmd.OutputTo acOutputReport, "rptInvoiceMultiple", acFormatPDF
Note that, using this method, a report cannot be filtered in the same way as can be done with the WhereCondition argument of the OpenReport method; it must be restricted by means of one or more parameters in the report's query. In my demo the invoice
number on the main invoice form is referenced as the parameter.
Ken Sheridan, Stafford, England
