If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
'Attaching' or linking a Word / pdf File to a Database Record
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 |
#2
|
|||
|
|||
'Attaching' or linking a Word / pdf File to a Database Record
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. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Graham A" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|