Drag and drop help

[whitewolf]

Hello everyone!

I'm developing a database in MS Access 2002,and I am wondering if it is possible to perform a drag/drop action in 2 listboxes in VBA,as well as between 2 subforms(the subforms each display tables,and I really only need to get drag/drop working on a per field basis,meaning,the user can only select and drag one value of a field and drop it in the other subform).

I am still very new at VBA,and I am developing the database as part of my course here in college.

All the books I have picked up from the library have been unable to help,and I have been unable to find any sample code on drag drop actions in VBA.

[Ecniv]

Drag n drop - in Access - not really possible. As to the subforms


hheee hehehe hah hahah
(from past experience)

You can't do much with subforms, especially interacting between the parent form and the subform.

At least this was the case in 97 and 2000, there just wasn't any functionality to do anything useful with them.

Ok, that said you wanta drag n drop facility, would look nifty, here are a couple of options you could look into:

1. Two listboxes, one holding all fields available, one with those selected, they move from one list to the other
2. An active X control, which could possibly use drag n drop, but I don't know if one exists already or whether you'd need to code your own
3. API calls to enable drag n drop - worth while learning these. You'd probably need to search online to get Vb coding as Microsoft.com seem to like putting all their examples into C

There are other ways I expect.. always are. As to whether the Access 2002 can do it, if you make it do it with subforms, please please please post up how you did it. I'd wanna know


Vince