Using a macro to open a pdf document (MS Access Forms)

Using a macro to open a pdf document
message from Dazza on 30 May 2004
Hi all, Can someone show me a method whereby a control button on a form will open up a specific pdf document? I have tried using "Run App" and keep getting an error message. Many thanks, Dazza

Arvin Meyer replied to Dazza on 30 May 2004

Try ShellExecute

http://www.mvps.org/access/api/api0018.htm

If that seems like too much for you right now, and pdf's are a registered
filetype, then you can use a hyperlink, or just the simple code for a
hyperlink in a label or button:

Private Sub Form_Current()
Me.Label1.HyperlinkAddress = "C:\FolderName\FileName.pdf"
End Sub

Then all you need to do is click on the label or button.

Archived message: Using a macro to open a pdf document (Microsoft Access Error Message)