linking files to access db 1

[2manyerrors]

Hi all,

I hope someone can help. I didn't see my post come up so I'm posting again. I hope there is no duplicates.

I have a table with the following fields;

ID
CustomerID
FileDescription
Date
DocPath

I then created a continuous form. The form has all the fields and two button.
I'm trying to get the first button to store the file path such as C:/files/mylife.pdf .
Then the second button when clicked will open the file.

I don't know how to do that. Please let me know if you can help. Thanks in advance.
I've attached my db.

 

[2manyerrors]

I forgot to include that I am using Access 2003.

 

[HiTechCoach]

See if one of my examples help:

http://www.hitechcoach.com/index.php?option=com_docman&task=doc_details&gid=7&Itemid=28

http://www.hitechcoach.com/index.php?option=com_docman&task=doc_details&gid=14&Itemid=28

Boyd Trimmell aka HiTechCoach
Microsoft Access MVP

 

[2manyerrors]

Thanks HiTechCoach,

Seems like the Access world is quite small. Searching through the web, I've founded your example a few days earlier. Thank you for posting. Have a wonderful day.

 

[2manyerrors]

Hi HiTechCoach

I was able to use your example successfully but ran into one problem that I can't seem to figure out. I hope you can help me out.

I have the form as a sub form and is trying to disable the attach button when there is a document attached already. I've set the form to only accept new entry. The form is a continuous form. What I am trying to do is not allow the user to change the attached file but only to add new files.

I hope you can help with this? Thank you ahead of time.