Solved

How to generate pdf files in MS Access 2007 in "silent mode"

Posted on 2010-09-02
3
533 Views
Last Modified: 2012-06-27
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.
0
Comment
Question by:DistillingExperts
3 Comments
 
LVL 14

Expert Comment

by:Bill Ross
ID: 33585286
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
0
 

Author Comment

by:DistillingExperts
ID: 33585441
Didn't work. Still showing while generating the pdfs.
0
 
LVL 10

Accepted Solution

by:
conagraman earned 500 total points
ID: 33617629
DistillingExperts:

get rid of the ", False"

just use :
DoCmd.OutputTo acOutputReport, "", acFormatPDF, Path & "\" & FileName

hope this helps
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question