Opening a specific Adobe file on my computer with access command button

[fstenoughsnoopy]

I am trying to make a button that will link to an adobe file on my
computer. The database is set up with different records for different
properties for a real estate company. There are adobe files stored
elsewhere for each individual property and i want to link each of those
to either a command button to automatically open that adobe file or
open it in the form using the built in adobe pdf reader. Any help would
be appreciated.

 

[fredg]

I am trying to make a button that will link to an adobe file on my
computer. The database is set up with different records for different
properties for a real estate company. There are adobe files stored
elsewhere for each individual property and i want to link each of those
to either a command button to automatically open that adobe file or
open it in the form using the built in adobe pdf reader. Any help would
be appreciated.

You can open the file the same as you would any other file:

Application.FollowHyperlink "PathToFoder\FileName.pdf"

If the file name is displayed in a particular field on your form, then
use:
Application.FollowHyperlink "PathToFoder\" & Me![ControlName] & ".pdf"

 

[fstenoughsnoopy]

the problem being, the address in the database is in two fields, and
the address/title of the folder is one. I need it to take the two
fields and combine them and then look up the folder in a group of
folders. Also I want it to open the pdf using the reader built into
Access. Dont know if it is possible but so far I'm just hyperlinking to
the specific folder(takes a long time)
Thanks for any help