Re: How to add an 'All Values' item in a filtered drop-down list q

Tech-Archive recommends: Fix windows errors by optimizing your registry

That's what I was starting to think. It's actually from Spider Web Woman that
I learned how to filter 2 drop-downs. So thank you twice.

"Kathleen Anderson [MVP - FrontPage]" wrote:

I think you can't do both. It might be possible to 'trap' the 'All Values"
selection and redirect them to another page with a different dropdown.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
FrontPage Support: http://www.frontpagemvps.com/




"Kelly Ogreman" <halfogre_halfman@h*tm**l.c*m> wrote in message
news:9CB65C58-92B0-488B-A09A-A5C6E60E97F9@xxxxxxxxxxxxxxxx
I tried that and it didn't work.
The first drop-down looks good, it has all the items and 'All Values'.
However if you choose 'All Values' the second drop down is blank. The
second
(filtered) drop-down obviously doesn't know what to return when 'All
Values'
is selected in the first drop-down. I also tried adding 'All Values' to
the
second drop-down and it returns nothing.

"Stefan B Rusynko" wrote:

Add an option using % as the value for All Values

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


"Kelly Ogreman" <halfogre_halfman@h*tm**l.c*m> wrote in message
news:A948F78C-C0F7-47D9-A559-7DF3D329E89B@xxxxxxxxxxxxxxxx
| I've been able to build a drop-down list that includes an 'All Values'
item.
| I've also been able to build a filtered database query using two
drop-down
| lists. But I don't know how to build a filtered list that includes an
'All
| Values' item.
|
| For instance the first drop-down has Accomodations, Attractions,
| Restaurants. If Restaurants were chosen, then next drop-down only
includes
| Restaurant items like Fine Dining, Chinese, etc., not Hotel, which only
| appears if Accomodations was chosen. But how do I include an 'All
Values'
| item in my drop-downs?






.

Relevant Pages

  • Re: OT: Why All the Trash in Alt.Sewing
    ... There may be slight variations between my instructions and what you see on your screen depending on what 'theme' you are using on your version of Thunderbird but the general procedure will be the same even if your screens/labels are slightly different to mine. ... Filters are used in a variety of ways but the most common ones are 'kill filing' where you want to block a specific poster who repeatedly posts inflammatory material and to filter message threads that you either want to ignore or to mark in some way to indicate that it is a thread that you are following or posting to. ... In the window below that select in the first drop-down menu, in the second drop-down menu and ensure that the poster's email address is shown in the final window. ...
    (rec.crafts.textiles.sewing)
  • Filters: multi-criteria cells ?
    ... Is it possible to have some rows selected by a filter on more then one ... first cell one of those texts strings, from a drop-down list. ... criteria list. ... because the selection is not as simple as selecting from a drop-down ...
    (microsoft.public.excel.misc)
  • Re: Filters: multi-criteria cells ?
    ... Then filter on column F. ... > first cell one of those texts strings, from a drop-down list. ... > because the selection is not as simple as selecting from a drop-down ...
    (microsoft.public.excel.misc)
  • Re: Filters: multi-criteria cells ?
    ... AFAIK you'll have to use the custom filter or have to create your own ... Why is 'custom filter' not suitable for you? ... > first cell one of those texts strings, from a drop-down list. ... > because the selection is not as simple as selecting from a drop-down ...
    (microsoft.public.excel.misc)
  • Re: PROBLEM WITH AUTOFILTER
    ... The drop-down on the filter only lists up to 1000 different values, ... I NOTICED WHEN I OPEN THE DROPDOWN WINDOW OF THE AUTOFILTER OF A COLOM, ... BUT I CANT SEE IT IN THE AUTO FILTER ...
    (microsoft.public.excel.newusers)