Drag and Drop single/multiple filenames onto Access textbox or Listbox from Explorer

Hi Guru's
I am writing a documentation application that requires granting the user the ability to show their file selections by dragging and dropping files onto an Access Listbox or Textbox so that the full pathnames of a file can be obtained.

I know it can be done in Visual Basic. But I'm spinning my wheels to make it happen in Access.

Thanks in advance,

Ted
LVL 1
tcalbazAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

jadedataMS Access Systems CreatorCommented:
Hey tcalbaz!

  I'm sorry to say this but,... what other options would you consider to this.
  I believe you would HAVE to use ActiveX controls for this as the standard control set for Access
  don't support D&D

regards
Jack
perkcCommented:
Take a look at this link. I've not used it but it sounds like what you're after.

http://www.mvps.org/access/api/api0032.htm

perkc

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
jadedataMS Access Systems CreatorCommented:
Thanx perkc!  I'll be adding that stuff to my tool kit...
tcalbazAuthor Commented:
Hi Guys,
Wow, the example offered by perkc really does look promising!  
Dev Ashish website is amazing. I tried examples used on his Website and in the Excel Spreadsheet Demo but somehow I couldn't get it to work with my Access 2000 application.  The best I could do is after dragging some file selections over to the Access Listbox was to get the ICON to switch to a plus cursor indicating that it had data to drop.  

I did notice that the Excel solution was originally offered as a solution for Access 97 because Access 97 VBA doesn't have an AddressOf Function.   Access 2000 evidently does.

So I guess it's a case of being tantalizingly close to a solution but not yet on the target.
It looks like the right direction.
Has anyone been fortunate enough to make all this work in Access 2000 or Access 97 yet?

Many thanks perc and jadedata,

Ted
tcalbazAuthor Commented:
Guys thank you for your comments and assistance. But it seems that this problem is not solvable. Perkc came the closest.
Thank you
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.