Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2007
    Posts
    72

    Unanswered: Criteria for multiple wildcard search in one field

    My Access 2003 mdb is a library catalogue. I have a QBF_Form with a text box for [Title] to search the title field. The criteria is:

    Like "*" & [Forms]![QBF_Form]![Title] & "*"

    This works but I want to know how to write criteria that will find words in the Title field that aren't next to each other.

    e.g. Type in text box (Greenwich Blackheath) to find the following titles:

    1. The Greenwich and Blackheath Study
    2. Blackheath, Greenwich and Lewisham transport study
    etc., etc.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I think this thread should give you all you need
    George
    Home | Blog

  3. #3
    Join Date
    Jul 2007
    Posts
    72
    Thanks georgev that looks like what I want. I'm pretty new at this and I'm unsure where to put that information?

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Create yourself a search button
    Right click it and "Build Event"
    George
    Home | Blog

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    probably the only way to do this is to write your own code that creates the SQL.. rather than using a query created by the query designer.

    so you need to have a look at recordsets, then you have to decide if you are using ADO or DAO.. its a long path but if you nee3d the felxibility to use multiple parameters in a query then you are tied to doign it this way.


    Access can only go part way for you, it does go a heck of a long way down the road but sometimes you've just go to go and get yer hands dirty with a bit of code..... some enjoy that part of Access Development, some hate it, some don't even know it exists.....
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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