DistillingExperts
asked on
How to generate pdf files in MS Access 2007 in "silent mode"
Hi,
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.
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
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.
ASKER
Didn't work. Still showing while generating the pdfs.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You might try turning off the screen during the procedure.
DoCmd.Echo False
run your print process...
DoCmd.Echo True
me.repaint <-If you're calling from a form.
Regards,
Bill