opening pdf with access

[Tammie]

As one of the report options, I would like the client to
be able to open a PDF file. The file is on a shared
drive - can someone share the syntax needed to do so. It
looks like the Runapp would be the best bet?

 

[Dirk Goldgar]

As one of the report options, I would like the client to
be able to open a PDF file. The file is on a shared
drive - can someone share the syntax needed to do so. It
looks like the Runapp would be the best bet?

If you have the path to the file, and the PDF extension is associated
with the appropriate program, you should be able to use
Application.FollowHyperlink to open the file. For example,

Dim strFilePath As String

strFilePath = "X:\Some Path\SomeFile.PDF"

Application.FollowHyperlink strFilePath