MS Access 2013 - Open a PDF from a form

Posted on 2015-01-25
Last Modified: 2015-01-26
I have created an MS Access 2013 form in which I want to place a link in a field on the form that when clicked will open a PDF specific to the current record.   Each record will be connected to its own PDF.

All PDFs to be used will reside in a subdirectory.

Question:  What format should the field be in the table that will contain the path to open the PDF.
Question:  From the field on the form can I just copy the path and file name and paste it into the field.

Thanks for your suggestions.
Question by:Lou Dufresne
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 24

Accepted Solution

Phillip Burton earned 500 total points
ID: 40570307
>Question:  What format should the field be in the table that will contain the path to open the PDF.
It can be Hyperlink or Text

>Question:  From the field on the form can I just copy the path and file name and paste it into the field.

However, clicking on it will not launch it. Instead, you right-hand click it and go to Hyperlink - Open Hyperlink (if you have chosen Hyperlink instead of Text).

I would not suggest that clicking on it would launch it; it you did that, then how could the user edit it instead of click it?

Instead, create a Command Button and cancel the window. Select it and in the properties, select "On Click" and select "[Event Procedure]". Then click on ... and a new window will open, which will contain something like:

Private Sub Command20_Click()

End Sub

Open in new window

In the middle, type


Where [Hyperlink] (the one in hard brackets) is your field.

Author Closing Comment

by:Lou Dufresne
ID: 40570594
Thanks for your assistance.  This is what I needed.

Featured Post

Don't Miss ATEN at InfoComm 2017!

Visit booth #2167 to see the  new ATEN VM3200 32 x 32 Modular Matrix Switch. Other highlights include the VE8950 4K HDMI Over IP Extender, VS1912 12-Port DP Video Wall Media Player  and VK2100 ATEN Control System. Register now with Free Pass Code ATEN288!

Question has a verified solution.

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

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

717 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