[AccessD] A strange situation

...me, I just hate checkboxes :)

...can you cascade the choices to shorten the lists?

...or drag n' drop from one listbox to another to show selections

...or move to using the listview rather than the listbox
...it provides so much more flexibility in the user interface,
conditional formatting by rows, colors, checkboxes, etc.
...especially nice if you already use the treeview

...if this is a full access install, then the fieldlist from the accwiz.dll
is available as well with a lot more flexibility and no registration 
required
...see Lebans for code.

William

--------------------------------------------------
From: "jwcolby" <jwcolby at colbyconsulting.com>
Sent: Friday, April 30, 2010 4:53 PM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] A strange situation

> Well...
>
> I like it except for two issues.
>
> 1) Users occasionally get confused between what is selected - dark or 
> light.  Or is that just me?  ')
> 2) If there are a lot of groups it would either require a long list 
> control or a scroll.  There are
> potentially up to 32 groups, though in practice we only have a handful at 
> the moment.
>
> I am going to be setting up "table driven" security where a table has 
> records for each form with the
> visible, allowedits etc properties.  The "security officer" can manipulate 
> these records via the
> form we are discussing.
>
> Additionally The user will be able to manipulate visible and enabled 
> properties for controls on the
> form as they are manipulating the form properties.  A list is MUCH 
> simpler, that is for sure.
>
> The list would contain the names of the security groups.  The "selected" 
> groups would be able to
> manipulate the property.  The programming would be much simpler for sure.
>
> I am going to give this a run and see what it looks like.
>
> John W. Colby
> www.ColbyConsulting.com
>
>
> William Hindman wrote:
>> ...more than that, why use 32 checkboxes at all? ...just strikes me as a
>> clumsy user interface ...why not a multi-select listbox or combo that you
>> can hide/unhide at will on the main form itself ...give it a Like* search
>> box header to avoid long scrolls if needed.
>>
>> William
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>