H
hgoslin
Hi
I need to create an Access database to track a number of documents
that are created and stored during the tendering process. I have
created a number of tables with hyperlink fields that will store the
information eg Tender proposal document (a Word doc); Tender budget
document (an Excel book) and company profiles (pdf) from companies
submitting tenders. To create the hyperlink to each of these
documents in the form, at the moment I right click, choose Hyperlink,
Edit Hyperlink and navigate to the required document and select it.
The path and filename is then stored in the field, which is just what
I need. However, is there a more elegant way to browse and navigate
to a specific file and store this as a hyperlink? I have read the
information at: http://www.mvps.org/access/api/api0001.htm and get the
browse dialog box to disiplay, but how do I store the path and file
name in a hyperlink field?
Thanks
Heather
I need to create an Access database to track a number of documents
that are created and stored during the tendering process. I have
created a number of tables with hyperlink fields that will store the
information eg Tender proposal document (a Word doc); Tender budget
document (an Excel book) and company profiles (pdf) from companies
submitting tenders. To create the hyperlink to each of these
documents in the form, at the moment I right click, choose Hyperlink,
Edit Hyperlink and navigate to the required document and select it.
The path and filename is then stored in the field, which is just what
I need. However, is there a more elegant way to browse and navigate
to a specific file and store this as a hyperlink? I have read the
information at: http://www.mvps.org/access/api/api0001.htm and get the
browse dialog box to disiplay, but how do I store the path and file
name in a hyperlink field?
Thanks
Heather