Using Excel database results problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Michael Hoeben (anonymous_at_discussions.microsoft.com)
Date: 11/05/04 

Date: Thu, 4 Nov 2004 16:22:18 -0800

Have made a bit of progress.
I created a new page & a new database connection. Added
one field (product code) as my criteria & saved the page

I can input the search term (a product code) but the
entire excel database spreadsheet appears instead of just
the item I required.

Frankly, I don't even know what I did to get THAT to
work, but I went & added a 2nd field (description) to the
criteria. Saved the page & uploaded it.

However, when I do a search on that field, the entire
database spreadsheet appears which I don't want.

Advice appreciated please (before I lose ALL my hair ;-(
Thanks
Michael

>-----Original Message-----
>I forgot to mention that I don't need to save the search
>results anywhere. They just need to be displayed to the
>user.
>
>Michael
>
>>-----Original Message-----
>>I wish to enable a search facility on my site so users
>>can search a product list. But the result does not
>>display any records or show "no records found".
>>
>>I followed this article which appeared in an earlier
>>thread dated 4/10/04,
>>http://support.microsoft.com/default.aspx?scid=268948
>
>>and set up a new connection from scratch - but the
issue
>>remains.
>>
>>When I first tried the search this message appeared,
>>Method Not Allowed
>>The requested method POST is not allowed for the
>>URL /productsearch.asp.
>>
>>so i change the method to GET and still nothing - not
>>even the message of "no records found"
>>I have saved the page as asp. My example can be seen
>here.
>>http://www.kleeneze-people.co.uk/productsearch.asp
>>
>>I use frontpage2000.
>>
>>Can anyone help please?
>>
>>Thanks
>>Michael
>>.
>>
>.
>

Relevant Pages

  • frontpage results from excel database
    ... >>The requested method POST is not allowed for the ... one field as my criteria & saved the page ... I can input the search term (a product code) but the ... database spreadsheet appears which I don't want. ...
    (microsoft.public.frontpage.programming)
  • Re: improving performance by indexing query criteria fields
    ... establish relationships first in the relationships window. ... My advice is to index fields that you use to specify criteria and sort orders. ... important in a multi-user database, where the back-end is on a file server. ... appropriate records (assuming the query optimizer can use the index). ...
    (microsoft.public.access.setupconfig)
  • Re: improving performance by indexing query criteria fields
    ... establish relationships first in the relationships window. ... My advice is to index fields that you use to specify criteria and sort orders. ... important in a multi-user database, where the back-end is on a file server. ... appropriate records (assuming the query optimizer can use the index). ...
    (microsoft.public.access.queries)
  • Re: Find largest alphanumeric value matching alpha criteria in dat
    ... the "Calif Insert" is a changing criteria that I need to be ... able to input in a cell. ... then go to the database to find all the records that also contain that same ... refers to the database and to a cell on the template: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Showing certain record only
    ... In my database I have a toggle button that once pressed ... My Main form is called frmProject which gets it data from a query ... unbound textbox, txtZeros. ... I add the following criteria to the filtering query for the listbox, ...
    (microsoft.public.access.forms)