RE: Can I create a search engine?

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

From: Jackie L (anonymous_at_discussions.microsoft.com)
Date: 06/03/04


Date: Thu, 3 Jun 2004 08:56:08 -0700

You can create an unbound field on a form then query. In the query criteria line of the field (where "tree" would be located) you would need to refer to the unbound field in this way:
Like "*"&Forms![frmInput]![UnboundFieldName]&"*"

This will return any record with Tree in that field.

     
     ----- Scott wrote: -----
     
     How do I create a search engine of some kind for my database? (without having to setup a new query everytime)
     
     
     I have a database which contains a library of topics and related notes associated with books, movies, internet, etc.
     What I want to be able to do is search the database TOPICS field through some type of search engine to find all the resources that cover a particular Topic in my database and where they can be found.
     
     For example, if I want to find all the resources I have assoicated with TREES, I want to either be able to type in the word "trees" or maybe even use a drop down list and select trees and a page comes up with all the resouces associated with trees.
     
     Thanks for any help or suggestion



Relevant Pages

  • Re: recursive treeview fill - problem
    ... already know exactly what it's value is going to be, so don't make the database send that value back to you for every record it finds. ... You already know EOF is False, or you wouldn't be inside the loop in the first place. ... I suspect this is why you end up with too many items in your tree. ... A recursive call that executes a query will have the same problems as a nested query above. ...
    (comp.lang.pascal.delphi.misc)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: OT: SQL
    ... query processing. ... FROM Employees e, Employees m, Management mgt ... Manager and Employee Salaries. ... The scheme used does not model database files in general, ...
    (sci.logic)
  • Re: access 2003
    ... I removed the parameters from the form query source. ... boxes from the form header, events, code, etc and ran the form query source ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would be ...
    (microsoft.public.access.conversion)
  • RE: Import external data - web query
    ... Your reply for my query is very extensive, this is for importing a file from ... The data source I want isn't listed in the Select Data Source dialog box. ... information used to connect to a database. ... Check your driver First, make sure you have the right ODBC driver (Open ...
    (microsoft.public.excel.misc)