Solved

MS Access 2013 - Open a PDF from a form

Posted on 2015-01-25
2
672 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 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

Industry Leaders: 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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The advancement in technology has been a great source of betterment and empowerment for the human race, Nevertheless, this is not to say that technology doesn’t have any problems. We are bombarded with constant distractions, whether as an overload o…
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

696 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