Drag and Drop File to Access Form to retrieve file's path.. possible?

[adamcbest]

Here is the idea i'm trying to accomplish. i want to have a form with some sort of control that i can drag a file from say the desktop or another folder. when i drop the file on that control (textbox, whatever) it returns the full path of that file, so that i may manipulate in access.

an easy example is drag the file to a text box and when dropped on the text box it will display the full path of that file.

is this at all possible, prefereably without going with a 3rd party plug-in or other solution??

 

[PHV]

If you have a not too old version of access you may consider the FileDialog object.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[adamcbest]

i can already clikc a button to open up a dialog to browse to the file. but it has been requested that i see if there is some way to be able to drag the file in. here is another example

say there is an email that has a pdf attachment we want to save and keep record of the path. I want to be able to drag that attachment straight from the email attachment to the access control. when its dropped it will take the path of the file in the temp outlook attachments folder, copy the file to a name generated by access, place it in the folder generated by access, then save the path of that file within access so it can be easily found.

i can do all of this except drag the file to the control and retrieve a path. as of now the way i'm doing it is by taking the attachment, saving it to desktop, then browsing to desktop to find the file using the dialog. I want to eliminate the extra save to desktop and browse to that file to copy by somehow implementing a drag and drop to return the original file path.