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

  • Thread starter Thread starter Filip Neyt
  • Start date Start date
F

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
 
Filip Neyt said:
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
Click to expand...

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,
 
Back
Top