When creating a drop down list for filtering a database query (created with
DRW) is there a way to add "All" to the list for the option of NOT filtering
the database?

for instance:

Criterion1
Criterion2
Criterion3
All

Thanks for your help.

Stephen

FP2000: How to Add an All Values Item to a Database Query
http://support.microsoft.com/default...;en-us;q244968

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


Stephen Green <(E-Mail Removed)> wrote:
> When creating a drop down list for filtering a database query
> (created with DRW) is there a way to add "All" to the list for the
> option of NOT filtering the database?
>
> for instance:
>
> Criterion1
> Criterion2
> Criterion3
> All
>
> Thanks for your help.
>
> Stephen

Kathleen!

You're right on the money. However, though I can get the sample illustrated
on the reference page to work, when I add the same functionality to my
existing page, it breaks.

The only difference I can see is that in my page the main query is that my
criterion reads [fieldname] Equals [fieldname]. If I change the Equals to
Contains, my query breaks.

Can you (anyone?) take a look at
http://d758687.u36.infinology.net/dr...t_page_all.asp to see if you
can spot the error?

I really appreciate it.

Stephen

"Kathleen Anderson [MVP - FP]" <(E-Mail Removed)> wrote in message
news:ePEYZB%(E-Mail Removed)...
> FP2000: How to Add an All Values Item to a Database Query
> http://support.microsoft.com/default...;en-us;q244968
>
> --
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> http://www.spiderwebwoman.com/resources/
>
>
> Stephen Green <(E-Mail Removed)> wrote:
> > When creating a drop down list for filtering a database query
> > (created with DRW) is there a way to add "All" to the list for the
> > option of NOT filtering the database?
> >
> > for instance:
> >
> > Criterion1
> > Criterion2
> > Criterion3
> > All
> >
> > Thanks for your help.
> >
> > Stephen

Well, right after I hit Send, I fiddled a little more and now it seems to
work! I did change Equals to Contains. I don't know why there is a blank
space on the list, though...

Now that I have your attention, let me ask a question that I posted a while
ago but didn't get answered.

Is it possible to offer more that one drop-down to allow searching by
different criteria? Say by Zip Code or Age or...?

I tried creating the drop-down, but it wouldn't link properly to the query.

Thanks so much.

Stephen

"Stephen Green" <(E-Mail Removed)> wrote in message
news:upPVCl%(E-Mail Removed)...
> Kathleen!
>
> You're right on the money. However, though I can get the sample
illustrated
> on the reference page to work, when I add the same functionality to my
> existing page, it breaks.
>
> The only difference I can see is that in my page the main query is that my
> criterion reads [fieldname] Equals [fieldname]. If I change the Equals to
> Contains, my query breaks.
>
> Can you (anyone?) take a look at
> http://d758687.u36.infinology.net/dr...t_page_all.asp to see if
you
> can spot the error?
>
> I really appreciate it.
>
> Stephen
>
> "Kathleen Anderson [MVP - FP]" <(E-Mail Removed)> wrote in message
> news:ePEYZB%(E-Mail Removed)...
> > FP2000: How to Add an All Values Item to a Database Query
> > http://support.microsoft.com/default...;en-us;q244968
> >
> > --
> > ~ Kathleen Anderson
> > Microsoft MVP - FrontPage
> > Spider Web Woman Designs
> > http://www.spiderwebwoman.com/resources/
> >
> >
> > Stephen Green <(E-Mail Removed)> wrote:
> > > When creating a drop down list for filtering a database query
> > > (created with DRW) is there a way to add "All" to the list for the
> > > option of NOT filtering the database?
> > >
> > > for instance:
> > >
> > > Criterion1
> > > Criterion2
> > > Criterion3
> > > All
> > >
> > > Thanks for your help.
> > >
> > > Stephen
>
>

You can add a second DRW to the same page and have it post to the same
results page as the first.

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


Stephen Green <(E-Mail Removed)> wrote:
> Well, right after I hit Send, I fiddled a little more and now it
> seems to work! I did change Equals to Contains. I don't know why
> there is a blank space on the list, though...
>
> Now that I have your attention, let me ask a question that I posted a
> while ago but didn't get answered.
>
> Is it possible to offer more that one drop-down to allow searching by
> different criteria? Say by Zip Code or Age or...?
>
> I tried creating the drop-down, but it wouldn't link properly to the
> query.
>
> Thanks so much.
>
> Stephen
>
> "Stephen Green" <(E-Mail Removed)> wrote in message
> news:upPVCl%(E-Mail Removed)...
>> Kathleen!
>>
>> You're right on the money. However, though I can get the sample
>> illustrated on the reference page to work, when I add the same
>> functionality to my existing page, it breaks.
>>
>> The only difference I can see is that in my page the main query is
>> that my criterion reads [fieldname] Equals [fieldname]. If I change
>> the Equals to Contains, my query breaks.
>>
>> Can you (anyone?) take a look at
>> http://d758687.u36.infinology.net/dr...t_page_all.asp to see
>> if you can spot the error?
>>
>> I really appreciate it.
>>
>> Stephen
>>
>> "Kathleen Anderson [MVP - FP]" <(E-Mail Removed)> wrote in
>> message news:ePEYZB%(E-Mail Removed)...
>>> FP2000: How to Add an All Values Item to a Database Query
>>> http://support.microsoft.com/default...;en-us;q244968
>>>
>>> --
>>> ~ Kathleen Anderson
>>> Microsoft MVP - FrontPage
>>> Spider Web Woman Designs
>>> http://www.spiderwebwoman.com/resources/
>>>
>>>
>>> Stephen Green <(E-Mail Removed)> wrote:
>>>> When creating a drop down list for filtering a database query
>>>> (created with DRW) is there a way to add "All" to the list for the
>>>> option of NOT filtering the database?
>>>>
>>>> for instance:
>>>>
>>>> Criterion1
>>>> Criterion2
>>>> Criterion3
>>>> All
>>>>
>>>> Thanks for your help.
>>>>
>>>> Stephen

How do I do that? I tried creating a second drop-down at the top of the
page next to the first with different criteria, but it doesn't seem to be
linked properly to the query. Hitting Submit yields "No records returned".
See: http://localhost/anmt/drop_down_test_page_multiple.asp.

Thanks again.

Stephen

"Kathleen Anderson [MVP - FP]" <(E-Mail Removed)> wrote in message
news:OUv3S8%(E-Mail Removed)...
> You can add a second DRW to the same page and have it post to the same
> results page as the first.
>
> --
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> http://www.spiderwebwoman.com/resources/
>
>
> Stephen Green <(E-Mail Removed)> wrote:
> > Well, right after I hit Send, I fiddled a little more and now it
> > seems to work! I did change Equals to Contains. I don't know why
> > there is a blank space on the list, though...
> >
> > Now that I have your attention, let me ask a question that I posted a
> > while ago but didn't get answered.
> >
> > Is it possible to offer more that one drop-down to allow searching by
> > different criteria? Say by Zip Code or Age or...?
> >
> > I tried creating the drop-down, but it wouldn't link properly to the
> > query.
> >
> > Thanks so much.
> >
> > Stephen
> >
> > "Stephen Green" <(E-Mail Removed)> wrote in message
> > news:upPVCl%(E-Mail Removed)...
> >> Kathleen!
> >>
> >> You're right on the money. However, though I can get the sample
> >> illustrated on the reference page to work, when I add the same
> >> functionality to my existing page, it breaks.
> >>
> >> The only difference I can see is that in my page the main query is
> >> that my criterion reads [fieldname] Equals [fieldname]. If I change
> >> the Equals to Contains, my query breaks.
> >>
> >> Can you (anyone?) take a look at
> >> http://d758687.u36.infinology.net/dr...t_page_all.asp to see
> >> if you can spot the error?
> >>
> >> I really appreciate it.
> >>
> >> Stephen
> >>
> >> "Kathleen Anderson [MVP - FP]" <(E-Mail Removed)> wrote in
> >> message news:ePEYZB%(E-Mail Removed)...
> >>> FP2000: How to Add an All Values Item to a Database Query
> >>> http://support.microsoft.com/default...;en-us;q244968
> >>>
> >>> --
> >>> ~ Kathleen Anderson
> >>> Microsoft MVP - FrontPage
> >>> Spider Web Woman Designs
> >>> http://www.spiderwebwoman.com/resources/
> >>>
> >>>
> >>> Stephen Green <(E-Mail Removed)> wrote:
> >>>> When creating a drop down list for filtering a database query
> >>>> (created with DRW) is there a way to add "All" to the list for the
> >>>> option of NOT filtering the database?
> >>>>
> >>>> for instance:
> >>>>
> >>>> Criterion1
> >>>> Criterion2
> >>>> Criterion3
> >>>> All
> >>>>
> >>>> Thanks for your help.
> >>>>
> >>>> Stephen
>

Stephen:
If I click on that link it will take me to my server, not yours :-)

I would suggest creating a two cell table and put each DRW in its own cell.
To see how the first DRW is posting, in Normal View, right-click on the
form, select Form Properties, Send to other: Custom ISAPI, NSAPI, CGI, or
ASP Script. Click on Options and you should see the name of the results page
it is posting to. Follow the same procedure for the 2nd DRW and have it post
to the same page as the first.


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


Stephen Green <(E-Mail Removed)> wrote:
> How do I do that? I tried creating a second drop-down at the top of
> the page next to the first with different criteria, but it doesn't
> seem to be linked properly to the query. Hitting Submit yields "No
> records returned". See:
> http://localhost/anmt/drop_down_test_page_multiple.asp.
>
> Thanks again.
>
> Stephen
>
> "Kathleen Anderson [MVP - FP]" <(E-Mail Removed)> wrote in
> message news:OUv3S8%(E-Mail Removed)...
>> You can add a second DRW to the same page and have it post to the
>> same results page as the first.
>>
>> --
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> http://www.spiderwebwoman.com/resources/
>>
>>
>> Stephen Green <(E-Mail Removed)> wrote:
>>> Well, right after I hit Send, I fiddled a little more and now it
>>> seems to work! I did change Equals to Contains. I don't know why
>>> there is a blank space on the list, though...
>>>
>>> Now that I have your attention, let me ask a question that I posted
>>> a while ago but didn't get answered.
>>>
>>> Is it possible to offer more that one drop-down to allow searching
>>> by different criteria? Say by Zip Code or Age or...?
>>>
>>> I tried creating the drop-down, but it wouldn't link properly to the
>>> query.
>>>
>>> Thanks so much.
>>>
>>> Stephen
>>>
>>> "Stephen Green" <(E-Mail Removed)> wrote in message
>>> news:upPVCl%(E-Mail Removed)...
>>>> Kathleen!
>>>>
>>>> You're right on the money. However, though I can get the sample
>>>> illustrated on the reference page to work, when I add the same
>>>> functionality to my existing page, it breaks.
>>>>
>>>> The only difference I can see is that in my page the main query is
>>>> that my criterion reads [fieldname] Equals [fieldname]. If I
>>>> change the Equals to Contains, my query breaks.
>>>>
>>>> Can you (anyone?) take a look at
>>>> http://d758687.u36.infinology.net/dr...t_page_all.asp to
>>>> see if you can spot the error?
>>>>
>>>> I really appreciate it.
>>>>
>>>> Stephen
>>>>
>>>> "Kathleen Anderson [MVP - FP]" <(E-Mail Removed)> wrote in
>>>> message news:ePEYZB%(E-Mail Removed)...
>>>>> FP2000: How to Add an All Values Item to a Database Query
>>>>> http://support.microsoft.com/default...;en-us;q244968
>>>>>
>>>>> --
>>>>> ~ Kathleen Anderson
>>>>> Microsoft MVP - FrontPage
>>>>> Spider Web Woman Designs
>>>>> http://www.spiderwebwoman.com/resources/
>>>>>
>>>>>
>>>>> Stephen Green <(E-Mail Removed)> wrote:
>>>>>> When creating a drop down list for filtering a database query
>>>>>> (created with DRW) is there a way to add "All" to the list for
>>>>>> the option of NOT filtering the database?
>>>>>>
>>>>>> for instance:
>>>>>>
>>>>>> Criterion1
>>>>>> Criterion2
>>>>>> Criterion3
>>>>>> All
>>>>>>
>>>>>> Thanks for your help.
>>>>>>
>>>>>> Stephen

What an jerk I am! Here is the real link:

http://d758687.u36.infinology.net/dr...e_multiple.asp

The drop down on the left works (its the original); the one on the right
doesn't...

In fact, I did expand the table so the second drop down would be in its own
cell. And I checked to make sure the form was posting to the right place -
the same page.

Stephen

"Kathleen Anderson [MVP - FP]" <(E-Mail Removed)> wrote in message
news:enXDwp$(E-Mail Removed)...
> Stephen:
> If I click on that link it will take me to my server, not yours :-)
>
> I would suggest creating a two cell table and put each DRW in its own
cell.
> To see how the first DRW is posting, in Normal View, right-click on the
> form, select Form Properties, Send to other: Custom ISAPI, NSAPI, CGI, or
> ASP Script. Click on Options and you should see the name of the results
page
> it is posting to. Follow the same procedure for the 2nd DRW and have it
post
> to the same page as the first.
>
>
> --
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> http://www.spiderwebwoman.com/resources/
>
>
> Stephen Green <(E-Mail Removed)> wrote:
> > How do I do that? I tried creating a second drop-down at the top of
> > the page next to the first with different criteria, but it doesn't
> > seem to be linked properly to the query. Hitting Submit yields "No
> > records returned". See:
> > http://localhost/anmt/drop_down_test_page_multiple.asp.
> >
> > Thanks again.
> >
> > Stephen
> >
> > "Kathleen Anderson [MVP - FP]" <(E-Mail Removed)> wrote in
> > message news:OUv3S8%(E-Mail Removed)...
> >> You can add a second DRW to the same page and have it post to the
> >> same results page as the first.
> >>
> >> --
> >> ~ Kathleen Anderson
> >> Microsoft MVP - FrontPage
> >> Spider Web Woman Designs
> >> http://www.spiderwebwoman.com/resources/
> >>
> >>
> >> Stephen Green <(E-Mail Removed)> wrote:
> >>> Well, right after I hit Send, I fiddled a little more and now it
> >>> seems to work! I did change Equals to Contains. I don't know why
> >>> there is a blank space on the list, though...
> >>>
> >>> Now that I have your attention, let me ask a question that I posted
> >>> a while ago but didn't get answered.
> >>>
> >>> Is it possible to offer more that one drop-down to allow searching
> >>> by different criteria? Say by Zip Code or Age or...?
> >>>
> >>> I tried creating the drop-down, but it wouldn't link properly to the
> >>> query.
> >>>
> >>> Thanks so much.
> >>>
> >>> Stephen
> >>>
> >>> "Stephen Green" <(E-Mail Removed)> wrote in message
> >>> news:upPVCl%(E-Mail Removed)...
> >>>> Kathleen!
> >>>>
> >>>> You're right on the money. However, though I can get the sample
> >>>> illustrated on the reference page to work, when I add the same
> >>>> functionality to my existing page, it breaks.
> >>>>
> >>>> The only difference I can see is that in my page the main query is
> >>>> that my criterion reads [fieldname] Equals [fieldname]. If I
> >>>> change the Equals to Contains, my query breaks.
> >>>>
> >>>> Can you (anyone?) take a look at
> >>>> http://d758687.u36.infinology.net/dr...t_page_all.asp to
> >>>> see if you can spot the error?
> >>>>
> >>>> I really appreciate it.
> >>>>
> >>>> Stephen
> >>>>
> >>>> "Kathleen Anderson [MVP - FP]" <(E-Mail Removed)> wrote in
> >>>> message news:ePEYZB%(E-Mail Removed)...
> >>>>> FP2000: How to Add an All Values Item to a Database Query
> >>>>> http://support.microsoft.com/default...;en-us;q244968
> >>>>>
> >>>>> --
> >>>>> ~ Kathleen Anderson
> >>>>> Microsoft MVP - FrontPage
> >>>>> Spider Web Woman Designs
> >>>>> http://www.spiderwebwoman.com/resources/
> >>>>>
> >>>>>
> >>>>> Stephen Green <(E-Mail Removed)> wrote:
> >>>>>> When creating a drop down list for filtering a database query
> >>>>>> (created with DRW) is there a way to add "All" to the list for
> >>>>>> the option of NOT filtering the database?
> >>>>>>
> >>>>>> for instance:
> >>>>>>
> >>>>>> Criterion1
> >>>>>> Criterion2
> >>>>>> Criterion3
> >>>>>> All
> >>>>>>
> >>>>>> Thanks for your help.
> >>>>>>
> >>>>>> Stephen
>

What did you do with the Submit button from the second DRW? It seems that
the one you have is only taking it's order from the first one.

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


Stephen Green <(E-Mail Removed)> wrote:
> What an jerk I am! Here is the real link:
>
> http://d758687.u36.infinology.net/dr...e_multiple.asp
>
> The drop down on the left works (its the original); the one on the
> right doesn't...
>
> In fact, I did expand the table so the second drop down would be in
> its own cell. And I checked to make sure the form was posting to the
> right place - the same page.
>
> Stephen
>
> "Kathleen Anderson [MVP - FP]" <(E-Mail Removed)> wrote in
> message news:enXDwp$(E-Mail Removed)...
>> Stephen:
>> If I click on that link it will take me to my server, not yours :-)
>>
>> I would suggest creating a two cell table and put each DRW in its
>> own cell. To see how the first DRW is posting, in Normal View,
>> right-click on the form, select Form Properties, Send to other:
>> Custom ISAPI, NSAPI, CGI, or ASP Script. Click on Options and you
>> should see the name of the results page it is posting to. Follow the
>> same procedure for the 2nd DRW and have it post to the same page as
>> the first.
>>
>>
>> --
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> http://www.spiderwebwoman.com/resources/
>>
>>
>> Stephen Green <(E-Mail Removed)> wrote:
>>> How do I do that? I tried creating a second drop-down at the top of
>>> the page next to the first with different criteria, but it doesn't
>>> seem to be linked properly to the query. Hitting Submit yields "No
>>> records returned". See:
>>> http://localhost/anmt/drop_down_test_page_multiple.asp.
>>>
>>> Thanks again.
>>>
>>> Stephen
>>>
>>> "Kathleen Anderson [MVP - FP]" <(E-Mail Removed)> wrote in
>>> message news:OUv3S8%(E-Mail Removed)...
>>>> You can add a second DRW to the same page and have it post to the
>>>> same results page as the first.
>>>>
>>>> --
>>>> ~ Kathleen Anderson
>>>> Microsoft MVP - FrontPage
>>>> Spider Web Woman Designs
>>>> http://www.spiderwebwoman.com/resources/
>>>>
>>>>
>>>> Stephen Green <(E-Mail Removed)> wrote:
>>>>> Well, right after I hit Send, I fiddled a little more and now it
>>>>> seems to work! I did change Equals to Contains. I don't know why
>>>>> there is a blank space on the list, though...
>>>>>
>>>>> Now that I have your attention, let me ask a question that I
>>>>> posted a while ago but didn't get answered.
>>>>>
>>>>> Is it possible to offer more that one drop-down to allow searching
>>>>> by different criteria? Say by Zip Code or Age or...?
>>>>>
>>>>> I tried creating the drop-down, but it wouldn't link properly to
>>>>> the query.
>>>>>
>>>>> Thanks so much.
>>>>>
>>>>> Stephen
>>>>>
>>>>> "Stephen Green" <(E-Mail Removed)> wrote in message
>>>>> news:upPVCl%(E-Mail Removed)...
>>>>>> Kathleen!
>>>>>>
>>>>>> You're right on the money. However, though I can get the sample
>>>>>> illustrated on the reference page to work, when I add the same
>>>>>> functionality to my existing page, it breaks.
>>>>>>
>>>>>> The only difference I can see is that in my page the main query
>>>>>> is that my criterion reads [fieldname] Equals [fieldname]. If I
>>>>>> change the Equals to Contains, my query breaks.
>>>>>>
>>>>>> Can you (anyone?) take a look at
>>>>>> http://d758687.u36.infinology.net/dr...t_page_all.asp to
>>>>>> see if you can spot the error?
>>>>>>
>>>>>> I really appreciate it.
>>>>>>
>>>>>> Stephen
>>>>>>
>>>>>> "Kathleen Anderson [MVP - FP]" <(E-Mail Removed)> wrote in
>>>>>> message news:ePEYZB%(E-Mail Removed)...
>>>>>>> FP2000: How to Add an All Values Item to a Database Query
>>>>>>> http://support.microsoft.com/default...;en-us;q244968
>>>>>>>
>>>>>>> --
>>>>>>> ~ Kathleen Anderson
>>>>>>> Microsoft MVP - FrontPage
>>>>>>> Spider Web Woman Designs
>>>>>>> http://www.spiderwebwoman.com/resources/
>>>>>>>
>>>>>>>
>>>>>>> Stephen Green <(E-Mail Removed)> wrote:
>>>>>>>> When creating a drop down list for filtering a database query
>>>>>>>> (created with DRW) is there a way to add "All" to the list for
>>>>>>>> the option of NOT filtering the database?
>>>>>>>>
>>>>>>>> for instance:
>>>>>>>>
>>>>>>>> Criterion1
>>>>>>>> Criterion2
>>>>>>>> Criterion3
>>>>>>>> All
>>>>>>>>
>>>>>>>> Thanks for your help.
>>>>>>>>
>>>>>>>> Stephen

Kathleen!

I must be doing something wrong. The first drop-down and submit button were
created along withe the Database Results region below. I can add more
drop-downs using the DRW, but I don't get another submit button. If I were
to create a second DR region that would defeat the purpose of having
multiple selectors for the same region...

Thanks for tracking this.

Stephen

"Kathleen Anderson [MVP - FP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> What did you do with the Submit button from the second DRW? It seems that
> the one you have is only taking it's order from the first one.
>
> --
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> http://www.spiderwebwoman.com/resources/
>
>
> Stephen Green <(E-Mail Removed)> wrote:
> > What an jerk I am! Here is the real link:
> >
> > http://d758687.u36.infinology.net/dr...e_multiple.asp
> >
> > The drop down on the left works (its the original); the one on the
> > right doesn't...
> >
> > In fact, I did expand the table so the second drop down would be in
> > its own cell. And I checked to make sure the form was posting to the
> > right place - the same page.
> >
> > Stephen
> >
> > "Kathleen Anderson [MVP - FP]" <(E-Mail Removed)> wrote in
> > message news:enXDwp$(E-Mail Removed)...
> >> Stephen:
> >> If I click on that link it will take me to my server, not yours :-)
> >>
> >> I would suggest creating a two cell table and put each DRW in its
> >> own cell. To see how the first DRW is posting, in Normal View,
> >> right-click on the form, select Form Properties, Send to other:
> >> Custom ISAPI, NSAPI, CGI, or ASP Script. Click on Options and you
> >> should see the name of the results page it is posting to. Follow the
> >> same procedure for the 2nd DRW and have it post to the same page as
> >> the first.
> >>
> >>
> >> --
> >> ~ Kathleen Anderson
> >> Microsoft MVP - FrontPage
> >> Spider Web Woman Designs
> >> http://www.spiderwebwoman.com/resources/
> >>
> >>
> >> Stephen Green <(E-Mail Removed)> wrote:
> >>> How do I do that? I tried creating a second drop-down at the top of
> >>> the page next to the first with different criteria, but it doesn't
> >>> seem to be linked properly to the query. Hitting Submit yields "No
> >>> records returned". See:
> >>> http://localhost/anmt/drop_down_test_page_multiple.asp.
> >>>
> >>> Thanks again.
> >>>
> >>> Stephen
> >>>
> >>> "Kathleen Anderson [MVP - FP]" <(E-Mail Removed)> wrote in
> >>> message news:OUv3S8%(E-Mail Removed)...
> >>>> You can add a second DRW to the same page and have it post to the
> >>>> same results page as the first.
> >>>>
> >>>> --
> >>>> ~ Kathleen Anderson
> >>>> Microsoft MVP - FrontPage
> >>>> Spider Web Woman Designs
> >>>> http://www.spiderwebwoman.com/resources/
> >>>>
> >>>>
> >>>> Stephen Green <(E-Mail Removed)> wrote:
> >>>>> Well, right after I hit Send, I fiddled a little more and now it
> >>>>> seems to work! I did change Equals to Contains. I don't know why
> >>>>> there is a blank space on the list, though...
> >>>>>
> >>>>> Now that I have your attention, let me ask a question that I
> >>>>> posted a while ago but didn't get answered.
> >>>>>
> >>>>> Is it possible to offer more that one drop-down to allow searching
> >>>>> by different criteria? Say by Zip Code or Age or...?
> >>>>>
> >>>>> I tried creating the drop-down, but it wouldn't link properly to
> >>>>> the query.
> >>>>>
> >>>>> Thanks so much.
> >>>>>
> >>>>> Stephen
> >>>>>
> >>>>> "Stephen Green" <(E-Mail Removed)> wrote in message
> >>>>> news:upPVCl%(E-Mail Removed)...
> >>>>>> Kathleen!
> >>>>>>
> >>>>>> You're right on the money. However, though I can get the sample
> >>>>>> illustrated on the reference page to work, when I add the same
> >>>>>> functionality to my existing page, it breaks.
> >>>>>>
> >>>>>> The only difference I can see is that in my page the main query
> >>>>>> is that my criterion reads [fieldname] Equals [fieldname]. If I
> >>>>>> change the Equals to Contains, my query breaks.
> >>>>>>
> >>>>>> Can you (anyone?) take a look at
> >>>>>> http://d758687.u36.infinology.net/dr...t_page_all.asp to
> >>>>>> see if you can spot the error?
> >>>>>>
> >>>>>> I really appreciate it.
> >>>>>>
> >>>>>> Stephen
> >>>>>>
> >>>>>> "Kathleen Anderson [MVP - FP]" <(E-Mail Removed)> wrote in
> >>>>>> message news:ePEYZB%(E-Mail Removed)...
> >>>>>>> FP2000: How to Add an All Values Item to a Database Query
> >>>>>>> http://support.microsoft.com/default...;en-us;q244968
> >>>>>>>
> >>>>>>> --
> >>>>>>> ~ Kathleen Anderson
> >>>>>>> Microsoft MVP - FrontPage
> >>>>>>> Spider Web Woman Designs
> >>>>>>> http://www.spiderwebwoman.com/resources/
> >>>>>>>
> >>>>>>>
> >>>>>>> Stephen Green <(E-Mail Removed)> wrote:
> >>>>>>>> When creating a drop down list for filtering a database query
> >>>>>>>> (created with DRW) is there a way to add "All" to the list for
> >>>>>>>> the option of NOT filtering the database?
> >>>>>>>>
> >>>>>>>> for instance:
> >>>>>>>>
> >>>>>>>> Criterion1
> >>>>>>>> Criterion2
> >>>>>>>> Criterion3
> >>>>>>>> All
> >>>>>>>>
> >>>>>>>> Thanks for your help.
> >>>>>>>>
> >>>>>>>> Stephen
>