Pdf

[Kenln]

Does anyone know how to open a PDF from Access?

 

[pbaldy]

Shell or FollowHyperlink should both work. More info on both in VBA help.

 

[Kenln]

I need to select the PDF based on the current record (the PDF name is not fixed). I believe I can select the proper file name (I think).

But since it changes I'm not sure if a hyperlink will work.

How would I shell?

 

[Kenln]

I tried

Dim RetVal
RetVal = Shell("C:\Documents and Settings\kennis\My Documents\speed_up_xp.pdf", 1)

and I got 'Invalid Procedure Call of Argument'

 

[boblarson]

Use the FollowHyperlink method. Build the string and then call it:

Dim strPath As String

strPath = "C:\Test\" & Me.YourTextBox

FollowHyperlink strPath

 

[Kenln]

Awesome,

Thanks Bob!