Command question

[UltraJay]

Hello Sirs,

I'm new to this community.
I have a problem & need help.
In Access Form, how do you make a link to PDF file, so if you click on the
file name, it opens up the PDF file?

I've made a table of database & used form to display it on a text box.
Any help would be appreciated.
Thank you.

 

[fredg]

Hello Sirs,

I'm new to this community.
I have a problem & need help.
In Access Form, how do you make a link to PDF file, so if you click on the
file name, it opens up the PDF file?

I've made a table of database & used form to display it on a text box.
Any help would be appreciated.
Thank you.

Depends upon what you are actually storing in the field.
Using the form, code the control's (the one that displays the .pdf
file name) double-click event......

1) If you are storing just the pdf file name, i.e. MyReport.pdf
then use:

Application.FollowHyperlink "c:\PathToFile\" & Me.[ControlName]

2) If you are storing the path and the file name, i.e.
c:\PathToFile\MyReport.pdf
then use:

Application.FollowHyperlink Me.[ControlName]