Exporting a report to PDF, How do you add code to open the pdf

[jlk]

Hello!



I have a report that I export to PDF through code. I have this code attached to a button on my main form. When the code runs it saves the PDF to my selected folder ok but I can not work out what code to added to get the pdf file to open automatically after the export.

This is my code:

DoCmd.OutputTo acOutputReport, "rptFINALCentreTotals", acFormatPDF, , , , , acExportQualityScreen


Is anyone able to help me to work out what code needs to be added to have the pdf file open after export?

Many Thanks

[amrut]

Add "True" for Autostart as below
DoCmd.OutputTo acOutputReport, "rptFINALCentreTotals", acFormatPDF, , True, , , acExportQualityScreen

[roaftech]

An alternative solution, which may be more appropriate to older versions of Access, is to print to something like PDFcreator, where you have that programme's native controls available too.

Assuming that you have the pdf writer as your default printer, the basic code looks like this:
--------
Private Sub Print_Form_Click()
On Error GoTo Err_Print_Form_Click

DoCmd.PrintOut acSelection

Exit_Print_Form_Click:
Exit Sub

Err_Print_Form_Click:
MsgBox Err.Description
Resume Exit_Print_Form_Click

End Sub
---------
As an aside, I always output to pdf before committing to paper - apart from giving a record copy of the document for digital filing, it also allows me to check formatting, spelling and content before using any paper or toner.

[jlk]

Thank you both for your responses. Using True worked perfectly
Much appreciated.