Embedding Adobe Reader (AcroPDF.dll) In Access Form

Posted on 2007-08-10
Last Modified: 2013-11-28
I've tinkered around a while try to make Adobe PDF Reader work with Access. I added the reference from the following path:

C:\Program Files\Common Files\Adobe\Acrobat\ActiveX\AcroPDF.dll

Doing this allows me to drop an adobe control on the user form. However, no method or properties are visible.  Does anyone know if it is possible to embed the adobe reader into access?

The end result that I am really after is printing a series of PDF documents at once from stored file paths in the access database.  I would prefer to pre-choose the default-printer and automatically print all individual documents with minimal user interaction.  A working embedded acrobat reader should be able to provide this kind of functionality.  I've seen examples of calling adobe from a shell, but this would require considerable user interaction to individually print and close each PDF document.

Richard Broersma Jr.
Question by:rabroersma
    LVL 84

    Accepted Solution

    ActiveX controls in Access can be difficult to manage at times. In order to get the Intellisense dropdowns, you need to do this:

    Dim pdf As AcroPDF

    Set pdf = Me.AcroPDF0.Object

    With pdf
      .LoadFile "G:\Documents and Settings\SomeName\My Documents\SomeArticle.pdf"
    End With

    note the call to .LoadFile ... this will load a PDF, then the call to PrintWithDialog will actually do the heavy work.
    LVL 1

    Author Comment

    Your solution works perfectly.

    I had a little trouble with it on my home computer at first.  When I loaded the form with the adobe control, the form would freeze.  However, since I had adobe version 7 installed at home I thought I should give version 8 to see it the older version was causing the problem..  

    Once I upgraded to version 8 everything worked well.

    Thanks for the help.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Update 21-May-2015: I temporarily removed the source code and the code snippets to make major changes to the program. Regards, Joe A recent question here at Experts Exchange piqued my interest, so I decided to provide a thorough solution and publ…
    *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…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
    Sometimes we receive PDF files that are in the wrong orientation. They may be sideways or even upside down. This most commonly happens with scanned or faxed documents. It is possible to rotate the view of these PDFs with the free Adobe Reader produc…

    729 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

    19 Experts available now in Live!

    Get 1:1 Help Now