Link to home
Start Free TrialLog in
Avatar of DistillingExperts
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.
Avatar of Bill Ross
Bill Ross
Flag of United States of America image

Hi,

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
Avatar of DistillingExperts
DistillingExperts

ASKER

Didn't work. Still showing while generating the pdfs.
ASKER CERTIFIED SOLUTION
Avatar of conagraman
conagraman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial