'Attaching' or linking a Word / pdf File to a Database Record

[Graham A]

I have created a database to schedule and track the status of audits. Audit
Reports are either produced in MS Word or are pdf scans of handwritten
documents. I want to be able to 'attach' or 'save' the Word / pdf file to the
corresponding database record so that in future it can be opened directly
from the database record.

I am sure I have seen this done before on databases created by other people
but although I have searched various MS publications, as well as online and
offline help I can't find any description of how to do this.

If I remember correctly what I have seen before, by clicking on a button a
dialogue box is opened which allows the user to navigate to and select the
file that is required to be 'stored' with the current database record.

Can someone please tell me how to do it or point me to where I can find this
info.

Many thanks

 

[Arvin Meyer [MVP]]

All you need to do is save the path and filename to a field or fields in the
database. Then using the hyperlink property of the textbox on the form which
displays the information, or using some exterior code like:

http://www.mvps.org/access/api/api0018.htm

you will open the corresponding file.