PDF Office 2010 Library Excel 2010 Bible Access 2010 Bible PowerPoint 2010 Bible Word 2010 Free Books. Chapter 1: Where VBA Fits In 15. Right-click the name of any form or report and choose Design View. To see the class module for the open form or report, click the Code button on the toolbar or choose View➪Code from the Access.

I've got a Microsoft Access database, and some PDF files. Right now, my Access database just shows a link to the PDF file with a .pdf generic icon.

What I want is a thumbnail view (like you get in Windows Explorer) of the PDF.

Second, right now when I click the PDF link, it is opening the PDF externally in Adobe Reader. How can I get it to open in preview mode within Access?

crushcrush

2 Answers

All of these will need the use of an embedded activeX control in your access app. There are many of them, some free, some not, depending on what you are planning to do. For a 'view only' use, I think you should be able to find something free. We have been using the foxit reader and the more complex amyuni controls in our apps with some success.

The principle are the following:

• You have to add the corresponding activeX file in the available references of your app (VBA screen, tools, select)
• You can then insert the corresponding control on a form, altogether with some 'empty' menus or controls
• You can use these menus or controls to initiate the different methods available for the PDF control (choose a file, next/previous page, zoom in/out, etc.)
• Depending on the vendor, some of these methods can be directly embedded in the activeX control
• I am sure you can google and find some examples of such work with VBA or even VB

If you distribute your access app, you will then have to distribute the activeX file with it. In most of the cases (if not all), distribution of the activeX file is free.

Philippe GrondierPhilippe Grondier

As a normal rule, I don't like embedding things that use external software inside of a form.

However, Access 2010 does have a new web control. You place that control in a form and set the URL to the path name of the pdf (or picture etc.) then it will render and display that pdf inside of the form. This works quite well as long as some pdf viewer is installed.

I do caution these approaches since updates to PDF viewer or even users having a different pdf viewer can often cause problems and cost you support dollars. As noted, I think using the new web browser control is risky, but at least far less risk than most methods. Since the new browser control is native to Access 2010, then you can quite much attempt this idea in production code, but I would still try to stick with a simple click to view that launches whatever pdf software the user happens to be running on that computer.

Access Bible Pdf

Albert D. KallalAlbert D. Kallal

Not the answer you're looking for? Browse other questions tagged ms-accessvbapdf or ask your own question.

Hi how do i call a pdf file from a form in ms access please ?

• 5 Contributors
• forum6 Replies
• 1,663 Views
• 1 Year Discussion Span
• commentLatest Postby goldriverdancer

You don't say whether you want to call it from a menu or a button or something else, but whatever the mode, you'll want to do if from a macro attached to that mode.

In your form, create a button (for example) and for the OnClick property, call the macro macOpenPDF (for example). In the Action column, use 'runapp' and for the command line argument, you must reference the path and filename to Adobe Acrobat (the application) and then, the path to the actual document you want to open. In my test form, here is my command line argument for the runapp action:

King James Bible Pdf

C:Program FilesAdobeReader 8.0ReaderAcroRd32.exe c:clc-drive.pdf

Access 2010 Vba Bible Pdf

Save the macro and the form, then click that sucker and see it work! Of course, you can use this same method to open any document from any valid application, even text files in Notepad. But make sure your users will have the same applications at the same path destinations or the logic will fail.

Access 2010 Pdf Manual

Good luck- SLH