Drag & Drop records

[Tommy408]

I want the administrator to have a friendly user interface by having a drag and drop records from table to table. For example draging a regular customer and drop onto a membership customer table.
Any features in MS Access I should take a look at about doing this?

 

[IanAble]

You can achieve this by using two ListView controls, one populated with data from the regular customers table and the other with data from membership customers table.

You'll have to add a reference to the Windows Common Control OCX File. Open any module and look at the references list.

This post on another forum will get you started:

http://visualbasic.ittoolbox.com/documents/popular-q-and-a/drag-and-drop-with-listview-2947

 

[Tommy408]

Thank you for your reply IanAble.

 

[PHV]

Why not simply use the combo wizard in your data entry form ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MichaelRed]

I am suprised!!! Been using Ms. A. for a bit. Feverently believed teaching that "Drag & Drop" was not (directly) supported by Ms. A. Have seen / uaed several 'work-around' soloutions to sort-of-build-your-own. Also noted the 'thread' referenced by Ian is for VISUAL BASIC, not (necessarily) vbA, I will certainly try this and be delighted to learn how foolish I have been ...




MichaelRed

 

[IanAble]

You're right Michael. Sorry about that Tommy, look at the bit re List Boxes in

http://support.microsoft.com/?kbid=287642