Attaching Documents in an access database (table/form)

[JenIng]

Is it possible to include an active link to stored documents on a network
through acces? For example, I have created an access database (a table, form
and report) to track open projects and each project will have a project plan
and specification documents and I was hoping to be able to provide users a
one click link to this document. So when they are adding a project they can
attach the document, and when others need to view the document they can just
look at the item for a link. Not sure if it works this way (like in excel you
can hyperlink to a document in a cell).

Thanks in advance for your help.

 

[Jeanette Cunningham]

Yes, there are a couple of ways to do this.
One way is to make the field that stores the path and name of the document a
hyperlink field.
A more involved way is to use code to store the path for the document and
the name of the document is 2 different fields.
Use the common Open Save windows explorer for users to select the file to
save in the table. It needs the code called

Call the standard Windows File Open/Save dialog box

from http://www.mvps.org/access/api/api0001.htm

Your table needs a field for file name and a field for path.

Jeanette Cunningham

 

[KARL DEWEY]

Access has datatype of hyperlink also.