Solved

Drag & Drop files from explorer into an MS Access Form?

Posted on 2006-10-20
7
2,547 Views
Last Modified: 2008-02-01
I would like to be able to create a form that populates a table with the filenames and paths of files that are dragged and dropped into one of the the form's controls.

I've seen examples of how to facilitate drag & drop between text-based controls withing access, or from menu items or between list drop down boxes...  but that is not what I need.

I need to be able to drag a NON-MS-Access object (a file in a folder) onto a form and have the form populate with the attributres of the file.

Does anyone know if this is even possibe?
If so,how??

Thanks!
0
Comment
Question by:cef_soothsayer
[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
7 Comments
 
LVL 8

Assisted Solution

by:Jillyn_D
Jillyn_D earned 165 total points
ID: 17774139
Hi cef_soothsayer,

I've never seen a drag-and-drop done, but if you don't get an answer to that, you could certainly open an explorer window through Access and allow the users to select files by double-clicking them.  I've done this for selecting db's to compact and repair, but I don't see why you couldn't just capture the file name and path.

Good luck!
~Jillyn
0
 
LVL 15

Assisted Solution

by:cquinn
cquinn earned 167 total points
ID: 17774144
There is example code here that works using API calls:

http://www.mvps.org/access/api/api0032.htm
0
 
LVL 1

Author Comment

by:cef_soothsayer
ID: 17775104
cquinn,

I saw that earlier when googling, but couldn't get it to work.  The AddrOf() function is not included and the refered to download is writtenfor Excel and will not compile in access.

JillynD,

Good idea.  However, these files are coming from email and I'd actually like to drag & drop them in and have MS Access place them in a particular folder and rename them then put the new file/path into the fields of the source table for the form.

Thanks.
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 168 total points
ID: 17778282
As others have said, Access doesn't really do drag-n-drop. There are some ActiveX controls which may allow you to do this, but you'll still have to write the VBA code to manipulate the files after moving them to your folder.

I use Sky Software's Explorer controls in one of my Access projects. I can drag/drop files from outside Access into other folders, but I can't drop them onto native Access controls. The controls do expose a LOT of events/properties, so you may be able to work with them.

http://www.ssware.com/
0
 
LVL 1

Author Comment

by:cef_soothsayer
ID: 17893818
I still dont have a "good" answer to this, but I've created a work around so dont need it anymore.
I'll split the points.
Thanks.
0
 
LVL 84
ID: 17894379
I don't agree with the C grade; the correct answer was presented to you (i.e. Access doesn't provide drag-and-drop functionality) and while it may not have suited your needs, it _was_ the right answer and therefore deserves, at the very least, a B grade.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

738 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