Drag/Drop File onto Form field to get file path

Is there a way to drag and drop a file from the Microsoft File Explorer onto some sort of Access form field such that the corresponding table field will end up containing the full path to that file?

I'm creating a simple Access application that keeps track of meeting minutes.  I would like to include links to all documents that are presented at each meeting.

In the past I have required users to place all of the documents in a single directory and then used VBA to read the files in the directory and set the corresponding field values.

But in this case the documents are all over the place and it would be easier to just have the user drag-and-drop the file icon onto some form object to get the path.

Is this easy?  Difficult?  Impossible?
LVL 2
dastrwAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rockmuncherCommented:
There are no inbuilt DragDrop event for controls in Access, but this might get you out of trouble if you feel like doing a bit more research

http://support.microsoft.com/default.aspx?scid=kb;en-us;233274


An alternative would be to use common dialog or similar to allow users to browse for files.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SidFishesCommented:
this might do what you want

http://www.mvps.org/access/api/api0032.htm
0
dastrwAuthor Commented:
Thanks for these links.  Neither of these is exactly what I was looking for, but I will tuck them away for possible future use.

Right now I'm thinking about going with the standard file explorer interface that I have incorporated into Access forms before.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.