I am trying to sort a page. I use Frontpage 2003 and use Access DB.
http://www.vdvalist.com/locate.asp I would like to have a person first
select by Zip than by category. What I am trying to do is see if there is a
way when a person selects the Zip if I can give them only the choices that
are available for that zip in Category. As it stands if you don't know what
catagory is in what zip it gives you a "no records found".

Any help will be greatly appreciated.

You Might want to check out
http://www.spiderwebwoman.com/tutori...ledropdown.htm

HTH

Don
=============================
"vdvalsit" <(E-Mail Removed)> wrote in message
news:A0E0F671-0B29-4F04-8F61-(E-Mail Removed)...
|I am trying to sort a page. I use Frontpage 2003 and use Access DB.
| http://www.vdvalist.com/locate.asp I would like to have a person first
| select by Zip than by category. What I am trying to do is see if there is
a
| way when a person selects the Zip if I can give them only the choices
that
| are available for that zip in Category. As it stands if you don't know
what
| catagory is in what zip it gives you a "no records found".
|
| Any help will be greatly appreciated.

I've try this solution, but my seach page now shows all listings regardless
of which dropdowns I select.

"Don" wrote:

> You Might want to check out
> http://www.spiderwebwoman.com/tutori...ledropdown.htm
>
> HTH
>
> Don
> =============================
> "vdvalsit" <(E-Mail Removed)> wrote in message
> news:A0E0F671-0B29-4F04-8F61-(E-Mail Removed)...
> |I am trying to sort a page. I use Frontpage 2003 and use Access DB.
> | http://www.vdvalist.com/locate.asp I would like to have a person first
> | select by Zip than by category. What I am trying to do is see if there is
> a
> | way when a person selects the Zip if I can give them only the choices
> that
> | are available for that zip in Category. As it stands if you don't know
> what
> | catagory is in what zip it gives you a "no records found".
> |
> | Any help will be greatly appreciated.
>
>
>

Hi
You need to insert an ALL catagory at the top of the (select catagory)drop
down which is selected as the default.That way the search will presume
that you only want to search by zip code until you select a catagory.
here is the tutorial .
http://support.microsoft.com/default...;EN-US;293169s

Paul M

"vdvalsit" <(E-Mail Removed)> wrote in message
news:A0E0F671-0B29-4F04-8F61-(E-Mail Removed)...
> I am trying to sort a page. I use Frontpage 2003 and use Access DB.
> http://www.vdvalist.com/locate.asp I would like to have a person first
> select by Zip than by category. What I am trying to do is see if there is
a
> way when a person selects the Zip if I can give them only the choices
that
> are available for that zip in Category. As it stands if you don't know
what
> catagory is in what zip it gives you a "no records found".
>
> Any help will be greatly appreciated.

Sorry included an s on the end by mistake
http://support.microsoft.com/default...b;EN-US;293169

"p@doinghisbest" <P@doinghisbest> wrote in message
news:%(E-Mail Removed)...
> Hi
> You need to insert an ALL catagory at the top of the (select catagory)drop
> down which is selected as the default.That way the search will presume
> that you only want to search by zip code until you select a catagory.
> here is the tutorial .
> http://support.microsoft.com/default...;EN-US;293169s
>
> Paul M
>
> "vdvalsit" <(E-Mail Removed)> wrote in message
> news:A0E0F671-0B29-4F04-8F61-(E-Mail Removed)...
> > I am trying to sort a page. I use Frontpage 2003 and use Access DB.
> > http://www.vdvalist.com/locate.asp I would like to have a person first
> > select by Zip than by category. What I am trying to do is see if there
is
> a
> > way when a person selects the Zip if I can give them only the choices
> that
> > are available for that zip in Category. As it stands if you don't know
> what
> > catagory is in what zip it gives you a "no records found".
> >
> > Any help will be greatly appreciated.
>
>

Hummmm...

You should only be presented with one dropdown at a time..

What does the query look like??

Don
======================
"vdvalsit" <(E-Mail Removed)> wrote in message
news5E92B14-3C91-4EFC-8738-(E-Mail Removed)...
| I've try this solution, but my seach page now shows all listings
regardless
| of which dropdowns I select.
|
| "Don" wrote:
|
| > You Might want to check out
| > http://www.spiderwebwoman.com/tutori...ledropdown.htm
| >
| > HTH
| >
| > Don
| > =============================
| > "vdvalsit" <(E-Mail Removed)> wrote in message
| > news:A0E0F671-0B29-4F04-8F61-(E-Mail Removed)...
| > |I am trying to sort a page. I use Frontpage 2003 and use Access DB.
| > | http://www.vdvalist.com/locate.asp I would like to have a person
first
| > | select by Zip than by category. What I am trying to do is see if
there is
| > a
| > | way when a person selects the Zip if I can give them only the
choices
| > that
| > | are available for that zip in Category. As it stands if you don't
know
| > what
| > | catagory is in what zip it gives you a "no records found".
| > |
| > | Any help will be greatly appreciated.
| >
| >
| >

See if this Helps you some...

http://www.xmas-i-am.com/how_to_filter_drop-down.htm

This is just sorting to a drop-down and then to a table but if you can get
it this far-- you will then see on the second page, (that in page 4 of the
wizard) you can just select another drop-down and then the next page you can
use the table...

One of the key things is using a custom query..

SELECT* FROM Sample (TO)
SELECT DISTINCT Order FROM Sample

In the custom Query

Clear as mud...

HTH

Don
==========================
"Don" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
| Hummmm...
|
| You should only be presented with one dropdown at a time..
|
| What does the query look like??
|
| Don
| ======================
| "vdvalsit" <(E-Mail Removed)> wrote in message
| news5E92B14-3C91-4EFC-8738-(E-Mail Removed)...
|| I've try this solution, but my seach page now shows all listings
| regardless
|| of which dropdowns I select.
||
|| "Don" wrote:
||
|| > You Might want to check out
|| > http://www.spiderwebwoman.com/tutori...ledropdown.htm
|| >
|| > HTH
|| >
|| > Don
|| > =============================
|| > "vdvalsit" <(E-Mail Removed)> wrote in message
|| > news:A0E0F671-0B29-4F04-8F61-(E-Mail Removed)...
|| > |I am trying to sort a page. I use Frontpage 2003 and use Access DB.
|| > | http://www.vdvalist.com/locate.asp I would like to have a person
| first
|| > | select by Zip than by category. What I am trying to do is see if
| there is
|| > a
|| > | way when a person selects the Zip if I can give them only the
| choices
|| > that
|| > | are available for that zip in Category. As it stands if you don't
| know
|| > what
|| > | catagory is in what zip it gives you a "no records found".
|| > |
|| > | Any help will be greatly appreciated.
|| >
|| >
|| >
|
|

Here is what I tried and what it looks like:
http://www.vdvalist.com/locatepro1.asp
I can't get it to work at all

"Don" wrote:

> Hummmm...
>
> You should only be presented with one dropdown at a time..
>
> What does the query look like??
>
> Don
> ======================
> "vdvalsit" <(E-Mail Removed)> wrote in message
> news5E92B14-3C91-4EFC-8738-(E-Mail Removed)...
> | I've try this solution, but my seach page now shows all listings
> regardless
> | of which dropdowns I select.
> |
> | "Don" wrote:
> |
> | > You Might want to check out
> | > http://www.spiderwebwoman.com/tutori...ledropdown.htm
> | >
> | > HTH
> | >
> | > Don
> | > =============================
> | > "vdvalsit" <(E-Mail Removed)> wrote in message
> | > news:A0E0F671-0B29-4F04-8F61-(E-Mail Removed)...
> | > |I am trying to sort a page. I use Frontpage 2003 and use Access DB.
> | > | http://www.vdvalist.com/locate.asp I would like to have a person
> first
> | > | select by Zip than by category. What I am trying to do is see if
> there is
> | > a
> | > | way when a person selects the Zip if I can give them only the
> choices
> | > that
> | > | are available for that zip in Category. As it stands if you don't
> know
> | > what
> | > | catagory is in what zip it gives you a "no records found".
> | > |
> | > | Any help will be greatly appreciated.
> | >
> | >
> | >
>
>
>

It seems to work for me. What do you think is not working?

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



vdvalsit <(E-Mail Removed)> wrote:
> Here is what I tried and what it looks like:
> http://www.vdvalist.com/locatepro1.asp
> I can't get it to work at all
>
> "Don" wrote:
>
>> Hummmm...
>>
>> You should only be presented with one dropdown at a time..
>>
>> What does the query look like??
>>
>> Don
>> ======================
>> "vdvalsit" <(E-Mail Removed)> wrote in message
>> news5E92B14-3C91-4EFC-8738-(E-Mail Removed)...
>>> I've try this solution, but my seach page now shows all listings
>>> regardless of which dropdowns I select.
>>>
>>> "Don" wrote:
>>>
>>>> You Might want to check out
>>>> http://www.spiderwebwoman.com/tutori...ledropdown.htm
>>>>
>>>> HTH
>>>>
>>>> Don
>>>> =============================
>>>> "vdvalsit" <(E-Mail Removed)> wrote in message
>>>> news:A0E0F671-0B29-4F04-8F61-(E-Mail Removed)...
>>>>> I am trying to sort a page. I use Frontpage 2003 and use Access
>>>>> DB. http://www.vdvalist.com/locate.asp I would like to have a
>>>>> person first select by Zip than by category. What I am trying to
>>>>> do is see if there is a way when a person selects the Zip if I
>>>>> can give them only the choices that are available for that zip in
>>>>> Category. As it stands if you don't know what catagory is in
>>>>> what zip it gives you a "no records found".
>>>>>
>>>>> Any help will be greatly appreciated.

The one on your site works great. But on my site it seems that the "Posting"
doesn't work. For instance I choose zip code 94080 on first page. When I go
to next page it shows Network Systesm in first choice and 94015 in zip. In
zip 94080 I only have 1 category "supplier".

Shouldn't page 2 show Suppler in first choice and show "94080" in the second
block?

"Kathleen Anderson [MVP - FrontPage]" wrote:

> It seems to work for me. What do you think is not working?
>
> --
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> http://www.spiderwebwoman.com/resources/
>
>
>
> vdvalsit <(E-Mail Removed)> wrote:
> > Here is what I tried and what it looks like:
> > http://www.vdvalist.com/locatepro1.asp
> > I can't get it to work at all
> >
> > "Don" wrote:
> >
> >> Hummmm...
> >>
> >> You should only be presented with one dropdown at a time..
> >>
> >> What does the query look like??
> >>
> >> Don
> >> ======================
> >> "vdvalsit" <(E-Mail Removed)> wrote in message
> >> news5E92B14-3C91-4EFC-8738-(E-Mail Removed)...
> >>> I've try this solution, but my seach page now shows all listings
> >>> regardless of which dropdowns I select.
> >>>
> >>> "Don" wrote:
> >>>
> >>>> You Might want to check out
> >>>> http://www.spiderwebwoman.com/tutori...ledropdown.htm
> >>>>
> >>>> HTH
> >>>>
> >>>> Don
> >>>> =============================
> >>>> "vdvalsit" <(E-Mail Removed)> wrote in message
> >>>> news:A0E0F671-0B29-4F04-8F61-(E-Mail Removed)...
> >>>>> I am trying to sort a page. I use Frontpage 2003 and use Access
> >>>>> DB. http://www.vdvalist.com/locate.asp I would like to have a
> >>>>> person first select by Zip than by category. What I am trying to
> >>>>> do is see if there is a way when a person selects the Zip if I
> >>>>> can give them only the choices that are available for that zip in
> >>>>> Category. As it stands if you don't know what catagory is in
> >>>>> what zip it gives you a "no records found".
> >>>>>
> >>>>> Any help will be greatly appreciated.
>