Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

opening pdf document button

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Opening a PDF document from a button in Access

Opening a PDF document from a button in Access

ResolvedVersion 2016

Manny has attended:
Access Intermediate course
Access Advanced course

Opening a PDF document from a button in Access

Hello,

I have written a nice PDF that outlines instructions and the instructions of my database. I have build a button on my "home page", on click i would like it to launch the pdf for the user to review.

I have tried a couple of things but no luck. Any ideas? Ive tried these
----------------------------
Dim shell As Object
Set shell = CreateObject("WScript.Shell")

shell.Run "XXXXXXXXX"

-----------------------------

file = "C:\path\FileToOpen.pdf"
Set shell = CreateObject("WScript.Shell")
shell.Run Chr(34) & sfile & Chr(34), 1, False

----------------------------

RE: Opening a PDF document from a button in Access

Hi Manny,

Thank you for the forum question.




Application.FollowHyperlink "C://YourFilePath/MyFile.pdf"


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

RE: Opening a PDF document from a button in Access

I know there are hyperlink capabilities in Access, but have never used them. In reading the posts I've found it looks like these have changed

Mon 1 Oct 2018: Automatically marked as resolved.

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Access tip:

Display current date & time in column of any width

The worksheet function =NOW() returns the current date & time. When entered into a column which is not wide enough to display the value NOW returns, the cell displays ###

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.