VBA‎ > ‎

VBA to open Access report and print it to a PDF

Starting with Access 2007, Access has a built-in easy way to export an Access report to a PDF file:
Public Sub PrinttoPDF(strFilePDF As String)
    Dim RptName As String
    RptName = "rptReport"
    DoCmd.OpenReport RptName, acViewDesign, , , acHidden
    DoCmd.Close acReport, RptName, acSaveYes
    DoCmd.OutputTo acOutputReport, RptName, acFormatPDF, strFilePDF
End Sub