• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 447
  • Last Modified:

Access - Link to external file


I have a client table (client) and a document table (document). They are linked 1:m.

I want a user to use a form (called: client) with a subform (called: document) to enter a hyperlink into a record on the subform. The hyperlink will point to a document in an external folder.

The user will scan a document in, call up a customer record via the form named client and insert the hyperlink into the subform.  Once linked a user will be able to call up a customer record and click the link in the subform to launch the document into an external application (.doc . pdf .xls etc)

Thank you for any help assistance.
1 Solution
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
A hyperlink is nothing more than text (at least from a user's standpoint), you they could just enter/paste the info into a standard textbox. You'd want to store it in your db as a Hyperlink datatype.

Assuming your user has some program associated with the document's File extension, the hyperlink will work correctly.

If you would like to use the Windows Common Dialog to help the user locate the file, see here:
janice12345Author Commented:
Work really well. Very pleased.  Thank you. jan.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now