Using Access database and query to display data per user criteria

[david]

Hi,
I would like be able to have site visitors input some data which will be
used to create search criteria for querying an Access database, and then
output the query results to the web.
I need some suggestions on books or articles that shows how to do this step
by step, without programming.
Thanks.
David

 

[Kathleen Anderson [MVP - FrontPage]]

You can do that using the FrontPage Database Results Wizard, if your web
site is hosted on a Windows server that supports ASP and Access. This links
here:
http://www.google.com/search?hl=en&lr=&c2coff=1&q=frontpage+database+results+wizard+tutorials
should help you get started.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx

 

[david]

Hi Kathleen,
I followed the links you suggested, read thro a number of tutorials, the
last one being at http://www.spiderwebwoman.com/tutorials/doubledropdown.htm.
which shows the use of 2 drop downs sequentially.
Is there any tutorial or samples for doing this (which is what I am really
looking for):
step 1: present site visitors with a combination of say 20 drop downs and
check boxes, perhaps including option buttons as well; have visitor complete
the 20 or more inputs all at once;
step 2: feed the inputs collected in step 1 into a pre-existing query in the
..mdb database, run the query, and display the results to the site visitor.

I am hoping I can do the above with ACCESS and FrontPage. I have learned how
to build queries I need within ACCESS (without interacting with the WEB,
however.) And I have subscribed to a web hosting service that does support FP
and ASP.

Finally, is ACCESS the right tool for doing what I need (as described in
step 1 and 2 above)?

Thanks.

 

[Kathleen Anderson [MVP - FrontPage]]

Hi David:
I don't think you're going to find a tutorial on how to have 20 dropdowns on
one page, especially if each dropdown is dependent on the previous dropdown.
The best suggestion I can make is to start with the double dropdown tutorial
and expand on it. To be honest with you, I hope I never get asked to it,
it's a very tedious process.

To answer your other question, I would say Access is the right database,
depending on the size and expected traffic to the site.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx

 

[PaulFM]

I went throught the tutorial that David lists below
(http://www.spiderwebwoman.com/tutorials/doubledropdown.htm) and found it to
be extremely useful. Thank you! I did run into an issue I am hoping someone
can help on. I have Chinese characters in the database that I am displaying
on the web page. Oddly, the characters display in the drop downs, but not on
the results page. Also, rather than displaying the Chinese as garbage, the
results page indicates there are no results in the recordset. When I select
dropdowns that only provide result set in English, everything works fine and
the display page shows the records in English. Any thoughts on what is going
on and how I might fix?

Thank you!