Results 1 to 3 of 3
  1. #1
    hendrikbez is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2014
    Posts
    138

    Cannot get search to work

    I have make a access form, done everything, put buttons on, but I cannot get it to make the search in the order that I have put the search info in.


    I have put the file in zip to upload it, I do not know where to look to fix this error.

    I always go to the first record and type info in one of the boxes and then I press search
    Attached Files Attached Files

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    Code:
    Like "*" & [Forms]![Servers]![Account Name] & "*"
    In the search criteria of the query, the field names must be the same as the names on the form.

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I cannot get it to make the search in the order that I have put the search info in
    I don't understand what this means. Would you explain in more detail?


    In looking at your dB, I see some issues that you should change:

    - should use only letters and numbers in object names (exception is the underscore). NO SPACES, punctuation, or special characters.
    - be aware of reserved words: in table "Servers", "Application' and "Password" are reserved words. In the form, the button names "NEW", "Exit", "First", "Last" and "Next" are reserved words.

    The controls for entering your search terms should be unbound.
    Because they are bound you either change the data in the record or create a new record every time you try to search.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How does your search work?
    By Dorothy in forum Forum Suggestions
    Replies: 5
    Last Post: 08-21-2019, 07:02 AM
  2. Search Button with Text Box won't work
    By lisanoe in forum Forms
    Replies: 4
    Last Post: 12-16-2015, 10:02 PM
  3. Search what step is the repair work in
    By blueraincoat in forum Access
    Replies: 6
    Last Post: 04-14-2011, 02:49 AM
  4. !!!!Urgent!!!! Search code doesn't work!
    By Laetilae in forum Programming
    Replies: 4
    Last Post: 12-13-2010, 10:34 PM
  5. my search form won't work?
    By sams in forum Forms
    Replies: 5
    Last Post: 05-06-2010, 02:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums