Create PDF from Access Report WITHOUT Opening Adobe Acrobat Professional

Posted on 2011-10-03
Last Modified: 2013-11-27
I have successfully managed to create a PDF report from an MS Access 2010 database report.  It works GREAT and I plan to use it in a process that will generate a hundred or so reports (certificates for conference attendees).  However... I have run into one glitch that I cannot seem to get around.

Whenever I create a pdf report via the VBA code, it opens Adobe Acrobat Professional.  I can't figure out a way to turn off the setting that tells it to open after creating the pdf.  Talk about annoying.  Closing the Access report is simple.  But closing the Adobe app (or even better... creating the PDF without opening Acrobat) is proving to be a royal pain in the asterisk.

Appreciate any help you can provide.  

Question by:careybroph
    LVL 2

    Expert Comment

    there is a free utility called cutepdf...

    free and easy to use

    it will convert any document to pdf, it works like a printer..
    LVL 38

    Expert Comment

    by:Aaron Tomosky
    Here is code that uses it as a printer

    LVL 22

    Accepted Solution

    This is the easiest way in Access 2010

    DoCmd.OutputTo acOutputReport, "rptname", acFormatPDF, "Filename", 0

    The 0 at the end says don't start Adobe, use -1 to start it. You just need to dynamically set the filename for each certificate - prtesumably in some loop.


    Author Closing Comment

    Thanks!  That's the perfect solution.  I figured that MUST be a simple way to accomplish this without a bunch of extra code (it seems like such a logical option).  I looked and looked, but couldn't find that documented (or I misinterpreted it).

    Thanks again!

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    This article focuses on how to remove password security from multiple PDF files by Adobe Acrobat program. Sometimes it is essential to access the stored data items and to print, edit as well as copy content from Portable Document Format files in abs…
    *Adobe Acrobat 9 was used for this article.  Particular steps may vary depending on software versions. Adobe Acrobat has many, many variables that my be utilized to customize your forms for clarity and ease of use. The Form Editing Tool will be y…
    In this video, we show how to convert an image-only PDF file into a PDF Searchable Image file, that is, a file with both the image (typically from scanning) and text, which is created in an automated fashion with Optical Character Recognition (OCR) …
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    731 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now