Avatar of BFanguy
Flag for United States of America

asked on 

Access 2010 drag and drop file to row on form only need relative path / filename of the file that was dragged.

I am looking for a way for a user to be able to drag and drop 1 file to a row on a form.
When the file is dropped i want to run vba code that only needs the file name of the file that was drug to the control.

I am going to prompt them asking if they want to copy the file to the record.
If yes, then in vba, i am going to copy / rename the file into a different directory and then store the new relative path/filename with the record. (Note: I don't need it as a hyperlink, just the relative path / filename )

Any help would be greatly appreciated.
VBAMicrosoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon