Drew Wutka
DWUTKA at Marlow.com
Tue Oct 27 12:05:18 CDT 2009
Have a lot to do right now, but really the best way to deal with drag and drop WITHOUT API's is to just use the treeview control, it has it's own drag and drop capabilities (you can drag a file from a windows explorer window into a treeview control, and use plain old VBA to deal with the incoming file path). Also, as to the 'freezing' issue, this is due to the quirk of the Access 2000 (and later) issue with callback functions. Callback functions in Access 2000 (and later) will work just fine, until you go into the VBE window. Then Access will go bonkers. Drew -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of David McAfee Sent: Monday, October 26, 2009 12:12 PM To: dwaters at usinternet.com; Discussion concerning Visual Basic and related programming issues. Subject: Re: [dba-VB] Create a DLL for Access Drag Drop? Sounds like a project for Drew :) Does the database freeze immediately or after a while of using it? D On Mon, Oct 26, 2009 at 10:03 AM, Dan Waters <dwaters at usinternet.com> wrote: > Hello! > > I have some code from a forum that I believe may allow dragging a file to an > Access for so that the file's full path can be captured by the form. If > this can be done, then a file can be very easily 'attached' to an Access > database. > > The code comes from here: > http://bytes.com/topic/access/answers/197392-drag-drop > > The code was originally written by Felix Lima (MS Support Engineer), and > posted by Stephen Lebans. > > I first tried putting this code into an mdb, but the database froze because > the code that was waiting for a Windows Message ran continuously. > > So, I want to ask if someone can take this code and put it into a DLL file > like Felix says it should be. I've put it all into a small Access file that > I can send to you. If this works, I'll post a 'how to' in DB Advisors. > > Thanks! > Dan > > > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > > _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.