Attachments In MS Access

[Guest]

How do you add an attachment to a record to show up on a form? For example I
am working on a Complaint database and each complaint comes in on paper and I
scan it to a file. Then some of the data is entered into a form. When
people go back to look at the complaint I want there to be some type of link
that they can click on that will take them to the scanned file of the actual
paper complaint.

 

[Pat Hartman \(MVP\)]

You can store the full path to the document in a hyperlink field. Clicking
on the hyperlink will open the document.

 

[Guest]

Just to elaborate a little on what Pat said, whatever you do, DO NOT store
the actual files in your db. Rather, store the file path with the filename.
for more inf look at

http://www.mvps.org/access/forms/frm0030.htm

Basically whether it be a word doc, excel spreadsheet, image,... they all
get handled the same way. I would suggest you look at a few image sample dbs
to take inspiration, such as:

http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000007#images
http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000007#album
http://www.rogersaccesslibrary.com/download3.asp?SampleName=Pictures.mdb
http://www.rogersaccesslibrary.com/download3.asp?SampleName=PicturesLoad.mdb