Linking Data Files

L

Leigh0227

I want to link each record in an access table to it's corresponding word
document. Is there any way to do this? For instance a button on the end of
each row or something? Thanks for your help.

Kristie
 
J

John Vinson

I want to link each record in an access table to it's corresponding word
document. Is there any way to do this? For instance a button on the end of
each row or something? Thanks for your help.

Kristie
Click to expand...

One simple way is to put a Hyperlink field in your table, with a link
to the location of the document. This needs no code at all.

Alternatively, you could store the path and filename in a Text field
and write some simple command-button VBA code to launch Word and open
the document. See the VBA help for Shell.

John W. Vinson[MVP]
 
Top