By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,454 Members | 2,633 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,454 IT Pros & Developers. It's quick & easy.

attach files

P: n/a
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

Jan 25 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.
Jan 25 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.