Solved

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

Posted on 2003-11-18
5
520 Views
Last Modified: 2006-11-17
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
Comment
Question by:tcalbaz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 32

Expert Comment

by:jadedata
ID: 9774159
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
 
LVL 10

Accepted Solution

by:
perkc earned 500 total points
ID: 9774325
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
 
LVL 32

Expert Comment

by:jadedata
ID: 9774356
Thanx perkc!  I'll be adding that stuff to my tool kit...
0
 
LVL 1

Author Comment

by:tcalbaz
ID: 9781329
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
 
LVL 1

Author Comment

by:tcalbaz
ID: 9796142
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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question