Anybody done a 2 checkboxes per row dropdown list

19 Feb 2009 3:24 PM

Laphan

Hi All

I'm open to design suggestions on this!

Basically I have a dropdown list of say attirbutes and I want to give the
user the ability to tick the ones that they want and the ones they want to
omit so that when I query a database from their suggestion we can refine
down to a real specific. I'm envisaging that the dropdown list would look
like as follows:

[x] [ ] Football
[ ] [ ] Cricket
[ ] [x ] Snooker
[ ] [ ] Boxing
[x] [ ] Baseball
[ ] [ ] Rugby

Basically the first col of checkboxes is to say show all the people who ARE
interested in Football, Baseball, etc, but using the second col of
checkboxes they can OMIT the people that are interested in Snooker. Does
this make sense?

I would auto-fill this drop-down with the attributes, but I don't know how
to get 2 checkboxes in the dropdown list. Any ideas or a better way of
doing this?

Ideally I want it to work from a dropdown menu so that the user clicks the
dropdown and then the dropdown list appears below it. A cheat that I've
used several times, but not with 2 checkboxes!!

Thanks

19 Feb 2009 4:03 PM

Bob Butler

Show quote Hide quote

"Laphan" <please@dont.spam.com> wrote in message
news:eaOwBZqkJHA.1292@TK2MSFTNGP02.phx.gbl...
> Hi All
>
> I'm open to design suggestions on this!
>
> Basically I have a dropdown list of say attirbutes and I want to give the
> user the ability to tick the ones that they want and the ones they want to
> omit so that when I query a database from their suggestion we can refine
> down to a real specific. I'm envisaging that the dropdown list would look
> like as follows:
>
> [x] [ ] Football
> [ ] [ ] Cricket
> [ ] [x ] Snooker
> [ ] [ ] Boxing
> [x] [ ] Baseball
> [ ] [ ] Rugby
>

I'd probably use a grid control for something like that

19 Feb 2009 4:07 PM

Al Reid

Show quote Hide quote

"Laphan" <please@dont.spam.com> wrote in message news:eaOwBZqkJHA.1292@TK2MSFTNGP02.phx.gbl...
> Hi All
>
> I'm open to design suggestions on this!
>
> Basically I have a dropdown list of say attirbutes and I want to give the
> user the ability to tick the ones that they want and the ones they want to
> omit so that when I query a database from their suggestion we can refine
> down to a real specific. I'm envisaging that the dropdown list would look
> like as follows:
>
> [x] [ ] Football
> [ ] [ ] Cricket
> [ ] [x ] Snooker
> [ ] [ ] Boxing
> [x] [ ] Baseball
> [ ] [ ] Rugby
>
> Basically the first col of checkboxes is to say show all the people who ARE
> interested in Football, Baseball, etc, but using the second col of
> checkboxes they can OMIT the people that are interested in Snooker. Does
> this make sense?
>
> I would auto-fill this drop-down with the attributes, but I don't know how
> to get 2 checkboxes in the dropdown list. Any ideas or a better way of
> doing this?
>
> Ideally I want it to work from a dropdown menu so that the user clicks the
> dropdown and then the dropdown list appears below it. A cheat that I've
> used several times, but not with 2 checkboxes!!
>
> Thanks
>

Why not just check the ones that you want included? If not checked it's omitted. I don't understand the need for two check boxes
for a simple yes/no, true/false, include/omit. That happens if neither one is checked?

--
Al Reid

19 Feb 2009 4:30 PM

Laphan

Hi Guys

Thanks for getting back to me.

I'm just testing the possibility of layering one listbox on top of the other
with both actually having the same data, eg:

Y N
[ ] [ ] Football
[ ] [ ] Rugby
[ ] [ ] Boxing
etc etc

Basically the Y N are currently a label, the first col of checkboxes are
listbox 1 and then listbox 2, which also shows the names, is laid on top.

Having fun with this, not sure if it's going to be right!!

With regard to Al's comment, I can appreciate where you're coming from Al,
but I don't want to be hitting the DB with 5 'includes' and 35 'exclude'
parameters when a 2 x checkbox approach could be 5 includes and 2 excludes.
Does this make any sense??? As I write it I sometimes wonder how anybody
can understand my ramblings :0)

Show quoteHide quote

"Al Reid" <arei***@reidDASHhome.com> wrote in message
news:OXkuGuqkJHA.4028@TK2MSFTNGP03.phx.gbl...
"Laphan" <please@dont.spam.com> wrote in message
news:eaOwBZqkJHA.1292@TK2MSFTNGP02.phx.gbl...
> Hi All
>
> I'm open to design suggestions on this!
>
> Basically I have a dropdown list of say attirbutes and I want to give the
> user the ability to tick the ones that they want and the ones they want to
> omit so that when I query a database from their suggestion we can refine
> down to a real specific. I'm envisaging that the dropdown list would look
> like as follows:
>
> [x] [ ] Football
> [ ] [ ] Cricket
> [ ] [x ] Snooker
> [ ] [ ] Boxing
> [x] [ ] Baseball
> [ ] [ ] Rugby
>
> Basically the first col of checkboxes is to say show all the people who
> ARE
> interested in Football, Baseball, etc, but using the second col of
> checkboxes they can OMIT the people that are interested in Snooker. Does
> this make sense?
>
> I would auto-fill this drop-down with the attributes, but I don't know how
> to get 2 checkboxes in the dropdown list. Any ideas or a better way of
> doing this?
>
> Ideally I want it to work from a dropdown menu so that the user clicks the
> dropdown and then the dropdown list appears below it. A cheat that I've
> used several times, but not with 2 checkboxes!!
>
> Thanks
>

Why not just check the ones that you want included? If not checked it's
omitted. I don't understand the need for two check boxes
for a simple yes/no, true/false, include/omit. That happens if neither one
is checked?

--
Al Reid

19 Feb 2009 4:58 PM

Al Reid

After reading both yours and Bob's comments, I have a better idea what you are trying to accomplish. Perhaps you can put this an a
form and pup up the form at the appropriate location and just use check boxes and labels OR just pretend I didn't reply to this
thread :o)

--
Al Reid

Show quoteHide quote

"Laphan" <please@dont.spam.com> wrote in message news:%23vbpu9qkJHA.1288@TK2MSFTNGP02.phx.gbl...
> Hi Guys
>
> Thanks for getting back to me.
>
> I'm just testing the possibility of layering one listbox on top of the other
> with both actually having the same data, eg:
>
> Y N
> [ ] [ ] Football
> [ ] [ ] Rugby
> [ ] [ ] Boxing
> etc etc
>
> Basically the Y N are currently a label, the first col of checkboxes are
> listbox 1 and then listbox 2, which also shows the names, is laid on top.
>
> Having fun with this, not sure if it's going to be right!!
>
> With regard to Al's comment, I can appreciate where you're coming from Al,
> but I don't want to be hitting the DB with 5 'includes' and 35 'exclude'
> parameters when a 2 x checkbox approach could be 5 includes and 2 excludes.
> Does this make any sense??? As I write it I sometimes wonder how anybody
> can understand my ramblings :0)
>
>
>
> "Al Reid" <arei***@reidDASHhome.com> wrote in message
> news:OXkuGuqkJHA.4028@TK2MSFTNGP03.phx.gbl...
> "Laphan" <please@dont.spam.com> wrote in message
> news:eaOwBZqkJHA.1292@TK2MSFTNGP02.phx.gbl...
> > Hi All
> >
> > I'm open to design suggestions on this!
> >
> > Basically I have a dropdown list of say attirbutes and I want to give the
> > user the ability to tick the ones that they want and the ones they want to
> > omit so that when I query a database from their suggestion we can refine
> > down to a real specific. I'm envisaging that the dropdown list would look
> > like as follows:
> >
> > [x] [ ] Football
> > [ ] [ ] Cricket
> > [ ] [x ] Snooker
> > [ ] [ ] Boxing
> > [x] [ ] Baseball
> > [ ] [ ] Rugby
> >
> > Basically the first col of checkboxes is to say show all the people who
> > ARE
> > interested in Football, Baseball, etc, but using the second col of
> > checkboxes they can OMIT the people that are interested in Snooker. Does
> > this make sense?
> >
> > I would auto-fill this drop-down with the attributes, but I don't know how
> > to get 2 checkboxes in the dropdown list. Any ideas or a better way of
> > doing this?
> >
> > Ideally I want it to work from a dropdown menu so that the user clicks the
> > dropdown and then the dropdown list appears below it. A cheat that I've
> > used several times, but not with 2 checkboxes!!
> >
> > Thanks
> >
>
> Why not just check the ones that you want included? If not checked it's
> omitted. I don't understand the need for two check boxes
> for a simple yes/no, true/false, include/omit. That happens if neither one
> is checked?
>
> --
> Al Reid
>
>
>

19 Feb 2009 5:05 PM

Bob Butler

"Al Reid" <arei***@reidDASHhome.com> wrote in message
news:%23KPv3KrkJHA.1336@TK2MSFTNGP06.phx.gbl...
> After reading both yours and Bob's comments, I have a better idea what you
> are trying to accomplish. Perhaps you can put this an a
> form and pup up the form at the appropriate location

My thought was a grid control that is visible only when needed rather than
an additional form; either approach would probably work.

19 Feb 2009 4:31 PM

Bob Butler

"Al Reid" <arei***@reidDASHhome.com> wrote in message
news:OXkuGuqkJHA.4028@TK2MSFTNGP03.phx.gbl...
> Why not just check the ones that you want included? If not checked it's
> omitted. I don't understand the need for two check boxes
> for a simple yes/no, true/false, include/omit. That happens if neither
> one is checked?

Say you have a list of people and their choices:
person1=football
person2=football+snooker
person3=snooker+cricket
person4=cricket

If you include football you get person1 and person2
If you include football and omit snooker you get just person1
If you include cricket and omit football you get person3 and person4

Having both include and omit is important

19 Feb 2009 4:35 PM

Larry Serflaten

"Laphan" <please@dont.spam.com> wrote

> I'm open to design suggestions on this!

For either the dropdown list, or the dropdown menu,
the user isn't going to see the selections utill they select the
menu item, so why not just use a simple little form, which
they also won't see unless they select that menu item....

LFS

19 Feb 2009 4:43 PM

Dave O.

You're going to have difficulties doing this on a drop down list, the
expected action for a drop down would be to collapse as soon as a check box
state is changed so it would be hard to have a intuitive way to do multiple
selections and to get the drop down to collapse when done.
An easier solution (if you insist on double checkboxes - See Al Reids
message) would be to have another form that pops up with the list (perhaps
labels) and a bunch of checkboxes and a pair of buttons - "Save" & "Cancel"
or similar - you should be able to work out the details as required.

Regards
Dave O.

Show quoteHide quote

"Laphan" <please@dont.spam.com> wrote in message
news:eaOwBZqkJHA.1292@TK2MSFTNGP02.phx.gbl...
> Hi All
>
> I'm open to design suggestions on this!
>
> Basically I have a dropdown list of say attirbutes and I want to give the
> user the ability to tick the ones that they want and the ones they want to
> omit so that when I query a database from their suggestion we can refine
> down to a real specific. I'm envisaging that the dropdown list would look
> like as follows:
>
> [x] [ ] Football
> [ ] [ ] Cricket
> [ ] [x ] Snooker
> [ ] [ ] Boxing
> [x] [ ] Baseball
> [ ] [ ] Rugby
>
> Basically the first col of checkboxes is to say show all the people who
> ARE
> interested in Football, Baseball, etc, but using the second col of
> checkboxes they can OMIT the people that are interested in Snooker. Does
> this make sense?
>
> I would auto-fill this drop-down with the attributes, but I don't know how
> to get 2 checkboxes in the dropdown list. Any ideas or a better way of
> doing this?
>
> Ideally I want it to work from a dropdown menu so that the user clicks the
> dropdown and then the dropdown list appears below it. A cheat that I've
> used several times, but not with 2 checkboxes!!
>
> Thanks
>
>

20 Feb 2009 12:21 AM

Randy Birch

Here's a demo on using a grid to mimic a checkbox page:
http://vbnet.mvps.org/code/intrinsic/matrixcheckgrid.htm

For your purpose change the Const value for "LASTDRAWINGCOLUMN" to 2 and
run. You will get 3 columns two clickable checkbox columns, and a third for
the description/text.

--

Randy
ms mvp, visual basic
http://vbnet.mvps.org/

Show quoteHide quote

"Laphan" <please@dont.spam.com> wrote in message
news:eaOwBZqkJHA.1292@TK2MSFTNGP02.phx.gbl...
> Hi All
>
> I'm open to design suggestions on this!
>
> Basically I have a dropdown list of say attirbutes and I want to give the
> user the ability to tick the ones that they want and the ones they want to
> omit so that when I query a database from their suggestion we can refine
> down to a real specific. I'm envisaging that the dropdown list would look
> like as follows:
>
> [x] [ ] Football
> [ ] [ ] Cricket
> [ ] [x ] Snooker
> [ ] [ ] Boxing
> [x] [ ] Baseball
> [ ] [ ] Rugby
>
> Basically the first col of checkboxes is to say show all the people who
> ARE
> interested in Football, Baseball, etc, but using the second col of
> checkboxes they can OMIT the people that are interested in Snooker. Does
> this make sense?
>
> I would auto-fill this drop-down with the attributes, but I don't know how
> to get 2 checkboxes in the dropdown list. Any ideas or a better way of
> doing this?
>
> Ideally I want it to work from a dropdown menu so that the user clicks the
> dropdown and then the dropdown list appears below it. A cheat that I've
> used several times, but not with 2 checkboxes!!
>
> Thanks
>
>