Create search engines in access db?


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Create search engines in access db?

  1. #1
    Join Date
    Aug 2004
    Posts
    6

    Create search engines in access db?

    Hi,
    Ive been able to create forms that has a menu which looks up values from one field and displays the list of possible/closest matching entries.

    However, i cant seem to create one which uses multiple attributes:
    basically where i would have 4 different fields :
    - Day
    - Time
    - Type
    - Year

    and a user could input any of the values to search like on amazon book search facility, you can search by many different values using multple criteria and find the best possible match.?

    Is that possible on Access 2000? any helpful tips would be appreciated
    thanks
    Connie
    Seether Rock!

  2. #2
    Join Date
    Apr 2005
    Posts
    3
    Access 2000 and Access, in general, is a rapid development program and form values can be used to dynamically create multiple criteria for form filters and SQL strings.

    They don't provide a best possible match, but all matches which satisfy the specific criteria.

    The criteria and/or SQL string are substantially similar, but not identical in all respects to queries built in the SQL Servcer Enterprise Manager.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center