link to pdf

[kitty77]

I'm trying to create a hyperlink to a pdf based on a number.

So, I have a folder on my network where the pdf's live. On my form, I have a field with the number. Example, abc.pdf, 123.pdf.

I would like to be able to click on that field or value and it would link to the proper pdf.

Thanks...

 

[Gasman]

FollowHyperLink method?

https://docs.microsoft.com/en-us/office/vba/api/access.application.followhyperlink

 

[kitty77]

Not sure I explained it correctly...
I'm actually just looking to link to that pdf based on the number.

So, it would be the path \\somthing\ and the [field]

Example: \\path\abc.pdf if I click it or use a button, it would open the pdf if it exists.

 

[Gasman]

strFile = "\\somthing\" & Me.txtFileName
Application.FollowHyperlink strFile,,True

If the txtFileName control does not have the .pdf extension then add that as well.

HTH

 

[kitty77]

Perfect! Thanks everyone!