Open a pdf file from Access

[bginhb]

I have an application that requires User help. I want to use PDF files for this purpose as the help information contains both text and graphics so I don't want to get into the Microsoft help thing which is too complex for this application.



Is there a best way to launch the User's default PDF viewer by pointing at the file and doing the equivalent of double-clicking?

Any and all assistance would be appreciated.

Thnx

[pbaldy]

Check out FollowHyperlink in VBA help.

[bginhb]

Thanks for the suggestion. I went ahead and did as you suggested and got some results but ... the PDF opened in Internet Explorer even though Firefox is my default browser. Then the next time I ran it the PDF opened in my default PDF reader.

Here's the code ... embedded on a button click event.

Dim ctl As CommandButton
Dim strSearchPath As String

strSearchPath = CurDir & "\Help Screen -- Functions, Categories & Activities Selection 07-25-11.pdf"
Set ctl = Me!Command23

With ctl
' .Visible = False
.HyperlinkAddress = strSearchPath
.Hyperlink.Follow
End With

The inconsistancies make no sense to me!

[pbaldy]

Well, that's not the method I mentioned. Try

Application.FollowHyperlink strSearchPath

which should use whatever program is associated with PDF files to open it. On my PC, that's Adobe reader.

[bginhb]

Thanks for your assistance.

[pbaldy]

No problem; hopefully that worked for you.