[dba-VB] Create a DLL for Access Drag Drop?

Hi Drew,

I'm using Access 2003, and once the code starts running in the 'callback
procedure', Access does go bonkers.  I'm guessing that placing this
procedure into a DLL will solve that.

I found Q209898, which discusses dragging and dropping nodes in a treeview
control.  I also set up a form and was able to trigger the OLEDragOver event
and the OLEDragDrop event when I dragged a file across the control.  In both
there is a Data object argument, which I don't know how to use to get a
file's full path.

Have you been able to get a file's path using a treeview?  What events/code
did you use?

Thanks!
Dan

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: Tuesday, October 27, 2009 12:05 PM
To: Discussion concerning Visual Basic and related programming issues.
Subject: Re: [dba-VB] Create a DLL for Access Drag Drop?

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