Double Click a List Item to Open an Associated File

[dustinw101 via AccessMonster.com]

I'm trying to find some type of already built solution or template so I can
see the base code to help me out but can't seem to find anything. Would
appriciate any help.

I have 2 list boxes:
1. List of Documents Needed from a Customer
2. List of Documents Received from a Customer

What I want is when the user clicks on the an item from the Docs Needed list,
I want them to have to option to "attach" a file to that list entry as it
gets marked as a document received. Then at anytime when a user clicks on
one of the items in the Documents Received List, the user can view that
document. I don't want to actually attach the file into the record itself
becuase of bloating, my DB would max out in no time at all. Rather I want
the user to get prompted with an 'Open File' dialog box so that they can
select the file that needs to be attached. After the file is selected, I
want to rename it to something standard like (ClientID + - + UniqueRecordID),
then place it into a folder where all the docs area saved. Suggestions??
Thanks for any help guys!! Love this Site

 

[Klatuu]

Go to this site:
http://www.mvps.org/access/api/api0001.htm

It contains an API that presents the Common File Open Dialog. You can use
this to allow the user to navigate to the file. Once selected, it returns
the full path to the file.

Then use a hyperlink field in your table to store the path to the file.

 

[Dennis]

Dustinw101,

Did this resolve your question? If not, I have done exactly what I think
you want to do. If you have some additional questions or need some
additional help, please let me know. I will be glad to share what I have
done with you.

To get my e-mail address, you can go to my web site at www.solispcdoc.com
and click on the Contact Us tab. Please do NOT post my real address in the
newgroup as I don't want to be buried in spam and viruses.

A LOT of people from this forum helped me develop this code, so I will
freely share it with you.

 

[Klatuu]

Dennis,

There are two things wrong with your post.
First, all information should be provided here in the newgroup to be
avaiable to all who may have a similar question. Second, it makes one think
you might be using the groups as a marketing tool whick is expressly
forbidden.
I suggest you review the information at this site:

http://www.mvps.org/access/netiquette.htm