?
Solved

MS Access 2013 - Open a PDF from a form

Posted on 2015-01-25
2
Medium Priority
?
769 Views
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.
Ldufresne
0
Comment
Question by:Lou Dufresne
[X]
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
2 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 2000 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.
Yes.

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

[Hyperlink].Hyperlink.Follow

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

Author Closing Comment

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

Featured Post

The Ideal Solution for Multi-Display Applications

Check out ATEN’s VS1912 12-Port DP Video Wall Media Player at InfoComm 2017. Kerri describes how easy it is to design creative video walls in asymmetric layouts and schedule detailed playlists ahead of time with its advanced scheduling feature.

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
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…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

764 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