attaching documents to a record

  • Thread starter Thread starter Cizl
  • Start date Start date
C

Cizl

Is it possible to attach documents to a record with an
Access 2000 database. If so, how do I set it up so an end
user can attach a document using the forms I created.
 
Use a Hyperlink field.

If you want no more than one attachment per record, just add a Hyperlink
field to your table. Insert the hyperlink through the Insert menu, by
right-clicking. Alternatively, you could put a little command button beside
the text box on the form, and put this in the button's Click event
procedure:
Me.[NameOfYourHyperlinkFieldHere].SetFocus
RunCommand acCmdInsertHyperlink

If you may need to have multiple attachments per record, create a related
table with the hyperlinks. Use a subform where the user can insert different
hyperlinks on different rows.

If the idea of hyperlinks is new, see:
Introduction to Hyperlink fields
at:
http://users.bigpond.net.au/abrowne1/casu-09.html
 
Back
Top