Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Manchester, Gtr Manchester, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    user 'Keyword' search functionality - how? (2000/XP)

    The purpose is to construct a where clause to limit records returned by a query.

    Here's what I'm thinking.

    A memo field to hold the keywords.
    A (lookup) table of keywords.
    To maintain control/ quality of entry the user picks keywords from the list (can be multi-select)
    The user can add to the list.

    Not sure how a search would work
    Free typing? sounds nasty
    Pick from a list

    How would the sql statement be constructed? - I assume I'd need wildcards
    Will this work on the memo field?

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 15 Times in 15 Posts

    Re: user 'Keyword' search functionality - how? (2000/XP)

    Perhaps the thread starting at <post:=376,490>post 376,490</post:> will help. Also take a look at Forms: Adding a Search form to a database on the Access Web.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •