link to pdf (1 Viewer)

[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.

 

[Pat Hartman]

Gasman understood the request. I'll expand.

Do not use the hyperlink data type. Just define a text field in the table. If you want to show a different value as you can do with the hyperlink data type, use two columns. One for what you want to display and the other for the actual link.

Using the FollowHyperlink method, works on any file type that windows recognizes including web pages, pdf's, Excel, Word, etc.

 

[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!