Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > Access-L Developer's Libraries > Cerný, Jirí
  New Posts New Posts RSS Feed - MutuallyExclusiveLists.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


Please consider donating $1 per sample downloaded, (find out why here)

MutuallyExclusiveLists.mdb

 Post Reply Post Reply
Author
Message
Jirí Cerný View Drop Down
Contributor
Contributor


Joined: 24 Jun 2008
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote Jirí Cerný Quote  Post ReplyReply Direct Link To This Post Topic: MutuallyExclusiveLists.mdb
    Posted: 10 Jul 2008 at 5:56am
This sample demonstrates selecting the values from "Full" list, moving selected item 
to "Selected" list and removing from the "Full" list. Multiple selections, Select All, 
Unselect All are implemented.

Both "Full" and "Selected" lists are based on the temporary table, which is created 
on-the-fly at opening of the form. It contains ID and label (shown in the lists) taken 
from underlying data plus extra column to hold the flag describing the selection 
status  (selected/unselected).

Values can be moved between both lists through double clicking individual values 
or subset (specified using ovious Shift or Ctrl keys). Listboxes MultiSelect Property is 
set to Extended, row source is defined programmatically at opening of the form.

Closing the form destroys the temporary table, so any action utilizing selected 
values have to be created prior closing the form.

Download Access 2K: uploads/8/MutuallyExclusiveLists.zip

Back to Top
Sponsored Links


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down