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