Solved

MS Access 2013 - Open a PDF from a form

Posted on 2015-01-25
2
553 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
2 Comments
 
LVL 24

Accepted Solution

by:
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.
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
This article will shed light on the latest trends when it comes to your resume building needs. For far too long, the traditional CV format has monopolized the recruitment market.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

948 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

21 Experts available now in Live!

Get 1:1 Help Now