troubleshooting Question

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

Avatar of BFanguy
BFanguyFlag for United States of America asked on
VBAMicrosoft Access
12 Comments2 Solutions156 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 12 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros