Drag and Drop

  • Thread starter Thread starter Gary Robinson
  • Start date Start date
G

Gary Robinson

Hi All

This is my problem!! I have a form with fields which contain names of
members of staff. allocated to jobs etc. Also on the form is a list box
with the complete list of staff members in it. Is it possible to drag names
from the list box into the fields, or something to that effect??

Thanks in advance

Gary
 
You can use the AfterUpdate of the list box to run code and "enter" the
selected name in one of your textboxes.
 
Unfortunately there is no real support for drag and drop in ms-access.

This usually means you have to be a bit creative in terms of how you "move"
things from on box to another.

If you look at the following screen shot, it shows a listbox, and a "arrow"
to click on. This is works quite well in place of drag and drop.
Take a look at the 2nd screen shot at:

http://www.attcanada.net/~kallal.msn/Rides/Rides.html
 
Gary,

Access has nothing built-in to allow dragging and dropping between
listboxes. There are some third-party tools that may help:

A shareware version of Drag-N-Dropper for MS Access is available at
this web site: http://www.peterssoftware.com/dd.htm

Stephen Lebans has an example of a FieldList control that supports
drag and drop: http://www.lebans.com/vb_listbox.htm

The Forms Sample database provided by Microsoft has an example called
"Simulating Drag-And-Drop Capabilities". You can download the sample
database here: http://support.microsoft.com/default.aspx?scid=kb;EN-US;175066

Hope this helps,
 
Gary Robinson said:
Hi All

This is my problem!! I have a form with fields which contain names of
members of staff. allocated to jobs etc. Also on the form is a list box
with the complete list of staff members in it. Is it possible to drag names
from the list box into the fields, or something to that effect??

Thanks in advance

Gary
Click to expand...

As a number of others have noted, there is very little drag drop support in Access.

If you would consider use of a commercial component to replace
standard listbox in your application, our TList control will
make this EASY. You can just set the AutoDragMode property
for each instance of TList and that's it.

Drop me a note by e-mail and I'll be happy to send
further information on TList, and get you started with
evaluation - including samples showing use of TList
within Access.

Note that TList can be used like a Listbox, a Tree, or a Grid.

* * Please include a copy of this note with your reply

Jeff Bennett
(e-mail address removed)

Bennet-Tec Information Systems, Inc
50 Jericho Tpk, Jericho, NY 11753
Phone 516 997 5596, Fax - 5597
WWW.Bennet-Tec.Com

RELIABLE Component Software
and Software Development Services
* TList/Pro * ALLText HT/Pro * MetaDraw *

====================== ======================
 
Back
Top