Directory Listing with hyperlink to each item listed

[csc159]

I am trying to figure out how to get this to work.

Let's say I have 100 buildings to inspect. I have a form created that I can
view the details of each building. Then every month we inspect the buildings
and the report is scanned into a PDF and sometimes they may have a Word or
Excel Document that goes with it.

Each building has it's own folder on the server that holds these items.

What I would like to do is:

Do a DIR listing with the results of that building to show up in the form.
Then if I want to look at one of those documents I could double click the
item and it would launch.

I had planned on putting a field in each record that would tell where the
respective documents were (example: \\Server\Buildings\McDonalds\, \\Server\
Buildings\Lowes\, \\Server\Buildings\Bed&Bath\)

Can anyone help me.

Thanks

Chris

 

[Guest]

try using:

Application.FollowHyperlink \\Server\Buildings\McDonalds\DocumentName.doc

it seems quiet round here today.....

Good Luck!
Steve.