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

Adding file path names to an access record

P: 18
I have an Access database that is used to keep track of issues that the department receives. What we need is a way to add attachments to issues, but only by adding the path name that is a hyperlink to open the document.

More information -

I need to open a form from the main issues form (which I can do that).

The attachment form needs to have a browse button that allows the users to search through their documents to find the file. I need to have a table for the attachments which will include the following:

Attach_ID
Description
FilePathName (hyperlink)
Issue_ID (which will link it to the main issue record)

The above needs to be included in the attachment form as well.

Also, each record can have many attachments. The users need to be able to open these documents by clicking on the path name.

Would the best solution be to have a textbox that then populates a listbox with all of the attachments for each record?

I'm not sure how to do any of this and would really appreciate the help.

Thank you
Nov 5 '08 #1
Share this Question
Share on Google+
1 Reply


ADezii
Expert 5K+
P: 8,597

Post your reply

Sign in to post your reply or Sign up for a free account.