Execute a .PDF file from a command button 1

[RangerFan]

I am trying to open a specific .PDF file from an Access (2010) command button. Can anyone help with this? Any help would be greatly appreciated.

 

[PHV]

Have a look at the FollowHyperlink method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Andrzejek]

If you want to show your pdf file in, let's say Acrobat Reader (or any file in their associated program, which is so nice ) you may use:

Public Sub OpenDocument(strDocPath As String)
Dim G As Long
G = Shell("RUNDLL32.EXE URL.DLL,FileProtocolHandler " & strDocPath, vbNormalFocus)
End Sub

And just call it:
[tt]
Call OpenDocument("C:\Test\MyFile.pdf")
[/tt]

Have fun.

---- Andy

 

[RangerFan]

Thanks Andy for your time. Much appreciated!

 

[PHV]

Why reinvent the wheel ?
No need to create any function !

Application.FollowHyperlink strDocPath

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[RangerFan]

Thanks all for your help!!! Problem solved.