Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2004
    Posts
    5

    Unanswered: "Any part of field" match

    How can I make my search button have the "Any part of field" match as a default? with a simple query...


    I have a field in MS access with hundreds of words (cv)... I want to be able to find a word in "Any part of field"

    my try:

    WHERE ((([cv].[detail cv])=[detail]));

    detail is nowhere to find... i am prompt to give a value. fine. but it
    equals whole field; detail must be the sole value of the field detail cv...

    or with a macro ?
    help! thanks

  2. #2
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    try this;

    Code:
     WHERE ((([cv].[detail cv]) LIKE "*" & [detail] & "*"));
    ghozy.

  3. #3
    Join Date
    Jun 2004
    Posts
    5
    thanks you very much!

  4. #4
    Join Date
    Jun 2004
    Posts
    5

    macro

    How can i start a macro from startup ?

    i'm just able to strart with a form, query, etc but not a marco in my startup menu...

  5. #5
    Join Date
    Apr 2004
    Location
    Sydney Australia
    Posts
    369
    Quote Originally Posted by peterka
    How can i start a macro from startup ?

    i'm just able to strart with a form, query, etc but not a marco in my startup menu...
    If you call a macro Autoexec it will run when you open the data base window.

    You could also have a from open in start up and a macro running from Open event on the form.

    Mike

Posting Permissions

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