attach files

[kevcar40]

i have a form that i want to attach files to as hyperlinks
the problem is there could be upto 10 files attached to the form or
maybe none

How can i go about
1 creating the attachements and storing them in a table
2 Build a list of attached files for the user to view via a button

i have built the file path string so i am going to the folder where
the file is stored
i then want to click on the file and create the link between
record/form and file

when a user views the form i want the user to click a button (or maybe
a combobox)and a list of all files attached to the form/ record appear

thanks for your help
kevin

[salad]

kevcar40 wrote:

i have a form that i want to attach files to as hyperlinks
the problem is there could be upto 10 files attached to the form or
maybe none

How can i go about
1 creating the attachements and storing them in a table
2 Build a list of attached files for the user to view via a button

i have built the file path string so i am going to the folder where
the file is stored
i then want to click on the file and create the link between
record/form and file

when a user views the form i want the user to click a button (or maybe
a combobox)and a list of all files attached to the form/ record appear

thanks for your help
kevin

See http://www.mvps.org/access/api/api0001.htm to get a FileOpen dialog
to select a file.

Create a table that links to the master record. You can create a text
field or a hyperlink field to store the into. If a hyperlink, I usually
parse the display info from the hyperlink (see HyperlinkPart) and make
the foreground of the display text blue/underlined. In the dbl-click
event I call a modification of http://www.mvps.org/access/api/api0018.htm

Since you have multiple hyperlinks, use a continuous form or datasheet
as a subform to the main form.