Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Access Search (2003)

    All of a sudden, I'm not able to search in Access when I press Ctr+F. I click in the field I want to search in, but get no results. It's only just started happening. What could be the problem.

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

    Re: Access Search (2003)

    Does it happen in all tables, queries and forms?

    If so, have you tried quitting and restarting Access, or if that doesn't help, restarting your PC?

    If it still doesn't work, try Help | Detect and Repair... from within Access.

  3. #3
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Access Search (2003)

    It only happens in the Form view. If I try on table view, it's ok

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access Search (2003)

    Does it happen in other forms in the same database?

  5. #5
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Access Search (2003)

    It actually happens in the subform. It's the Production Problem database you helped me with. I can't understand what's happened, it was working perfectly until now. Nothing has changed. It will search in the table, but not the form. I done detect and repair.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access Search (2003)

    Can you search by selecting Edit | Find... or by clicking the Find button in the toolbar?
    Can you do other things in the subform (select values, edit them, ...)?

  7. #7
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Access Search (2003)

    No, Edit | Find does'nt work. I can edit the fields in the subform. In an earlier post on this database <post#=471469>post 471469</post#> you suggested using a query for the form, which I'm sure I did, but now the form and subform come from two tables, but I was still able to search, until now.

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access Search (2003)

    Perhaps someone can investigate the problem if you post a stripped down and zipped copy.

  9. #9
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Access Search (2003)

    Here it is. Thanks.

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access Search (2003)

    When I open the database in your zip file and convert it to Access 2000 format, then open the tblDaily Production Main form using the second option of the switchboard, I can use Ctrl+F without problems (see screenshot). If I open the form using the first option of the switchboard, it opens on a new record, so there is nothing to search for.

  11. #11
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Access Search (2003)

    Then I'm completely baffled. Quite rightly, the first option is for inputting data. I opened the form in edit mode (button 2), and tried searching in Actionee, and could not find the result I knew was there.

  12. #12
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Access Search (2003)

    Did you search for anything and get a result?

  13. #13
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access Search (2003)

    Whoa. In your first post, you stated "I'm not able to search in Access when I press Ctr+F". I interpreted this to mean that Ctrl+F didn't do anything. Now you write "... and could not find the result I knew was there". Do you mean that Ctrl+F does display the Find dialog, but that clicking Find Next reports that the item was not found while you're convinced it's there?

  14. #14
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Access Search (2003)

    The find dialog comes up OK, but no results

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

    Re: Access Search (2003)

    If you're searching for an Actionee, you must set Match in the dialog to Any part of field. If it's set to Whole field or to Start of field, you won't find LA, for example, since LA only occurs as second actionee, never as first or only one (in the database you attached).

Page 1 of 2 12 LastLast

Posting Permissions

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