Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 538
  • Last Modified:

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
0
tcalbaz
Asked:
tcalbaz
  • 2
  • 2
1 Solution
 
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
0
 
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
0
 
jadedataMS Access Systems CreatorCommented:
Thanx perkc!  I'll be adding that stuff to my tool kit...
0
 
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
0
 
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
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now