?
Solved

Embedding Adobe Reader (AcroPDF.dll) In Access Form

Posted on 2007-08-10
2
Medium Priority
?
10,280 Views
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.

TIA.
Regards,
Richard Broersma Jr.
0
Comment
Question by:rabroersma
2 Comments
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 19675620
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"
  .printWithDialog
End With

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

Author Comment

by:rabroersma
ID: 19676121
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.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
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…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

850 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