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?