Print Page | Close Window

MutuallyExclusiveLists.mdb

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Cerný, Jirí
Forum Description: Jirí Cerný's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=211
Printed Date: 19 Oct 2017 at 4:58am


Topic: MutuallyExclusiveLists.mdb
Posted By: Jirí Cerný
Subject: MutuallyExclusiveLists.mdb
Date 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: http://www.rogersaccesslibrary.com/forum/uploads/8/MutuallyExclusiveLists.zip - uploads/8/MutuallyExclusiveLists.zip



-------------
--

Email: mailto:Jiri.Cerny@pragonet.cz - Jiri.Cerny@pragonet.cz



Print Page | Close Window