How to generate pdf files in MS Access 2007 in "silent mode"
Posted on 2010-09-02
I am using Access to generated reports in pdf files, but when it generates it keeps poping up the generation itself. Is there a possibility to hide this from the user experience?
Right now I have the following:
DoCmd.OpenReport ReportName, acViewDesign
Reports(ReportName).Filter = strFilter
DoCmd.Close acReport, ReportName, acSaveYes
DoCmd.OpenReport ReportName, acViewPreview, , strFilter
DoCmd.OutputTo acOutputReport, "", acFormatPDF, Path & "\" & FileName, False
DoCmd.Close acReport, ReportName
Thank you in advance.