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

Michael Maddison michael at ddisolutions.com.au
Tue Oct 27 19:03:17 CDT 2009


Hi Dan,

In the dim dark past I think I did something like this.
IIRC you supply the Data object (can be anything) in the StartDrag(?)
event.

I could be wrong...

Cheers

Michael

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


_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com





More information about the dba-VB mailing list