Re: Using Access database and query to display data per user crite

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

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!

"david" wrote:

> 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]" wrote:
>
> > 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 <david@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
> > > 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
> >
> >
.

Quantcast