Drag and Drop Between 2 listboxes based on 1 table/query

[Filip Neyt]

I found a module to drag records from a listbox to another. Both listboxes
are on one from and based on the same table. the field ysnSelected keeps
track in which of the listboxes the record is placed (true= listbox 2, false
= listbox1).
I tried to use the module to develope a form to make a productionplanning. I
need a general listbox with all the records and I want to drag and drop them
in 5 other listboxes(which are 5 production lines). First I tried to use the
module in the same way I found it, but I used a query instead of a table,
and I used a intField (0 to 5) to define in which listbox the record is. I
first tried with only 2 listboxes (0 and 1) but it doen'st work. Should I
use a table instead of a query?
I also want a textbox under my Listboxes in my form with the sum of a field
in the listboxes.

The drag and drop module comes out an Access 2000 sample Forms database
(FrmSmp2000)

Can someone help me out?

Kind regards,


Filip

 

[Peter De Baets]

I found a module to drag records from a listbox to another. Both listboxes
are on one from and based on the same table. the field ysnSelected keeps
track in which of the listboxes the record is placed (true= listbox 2, false
= listbox1).
I tried to use the module to develope a form to make a productionplanning. I
need a general listbox with all the records and I want to drag and drop them
in 5 other listboxes(which are 5 production lines). First I tried to use the
module in the same way I found it, but I used a query instead of a table,
and I used a intField (0 to 5) to define in which listbox the record is. I
first tried with only 2 listboxes (0 and 1) but it doen'st work. Should I
use a table instead of a query?
I also want a textbox under my Listboxes in my form with the sum of a field
in the listboxes.

The drag and drop module comes out an Access 2000 sample Forms database
(FrmSmp2000)

Can someone help me out?

Kind regards,


Filip

There are some third-party drag and drop 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 . It allows you to execute custom
SQL or a custom function on drop.

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

Hope this helps,

 

[Peter De Baets]

I found a module to drag records from a listbox to another. Both listboxes
are on one from and based on the same table. the field ysnSelected keeps
track in which of the listboxes the record is placed (true= listbox 2, false
= listbox1).
I tried to use the module to develope a form to make a productionplanning. I
need a general listbox with all the records and I want to drag and drop them
in 5 other listboxes(which are 5 production lines). First I tried to use the
module in the same way I found it, but I used a query instead of a table,
and I used a intField (0 to 5) to define in which listbox the record is. I
first tried with only 2 listboxes (0 and 1) but it doen'st work. Should I
use a table instead of a query?
I also want a textbox under my Listboxes in my form with the sum of a field
in the listboxes.

The drag and drop module comes out an Access 2000 sample Forms database
(FrmSmp2000)

Can someone help me out?

Kind regards,


Filip

There are some third-party drag and drop 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 . It allows you to execute custom
SQL or a custom function on drop.

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

Hope this helps,