Results 1 to 12 of 12
  1. #1
    New Lounger
    Join Date
    May 2003
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Find feature in 2000 (Access 2000 SR-1)

    Hello,

    We are converting a 97 database into a 2000 database. One problem is that the find feature seems to have changed. I have a button on a form for find. In Access 97, the user just starts typing a few letters of the item they are searching for. The default settings are to "search all" fields and match "any part". They do not need to place the curser in the field they want to search for. The 2 most common fields they search are name and room number.

    Can the 2000 version be set to do the search in a similar way?

    Thanks,
    Linda

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

    Re: Find feature in 2000 (Access 2000 SR-1)

    You can set your default search option in the Edit/Search tab of Tools | Options... You'll want to select the middle option, I think.

  3. #3
    New Lounger
    Join Date
    May 2003
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find feature in 2000 (Access 2000 SR-1)

    Hi Hans,

    I'm sorry, I forgot to say, I tried that. Yes, the middle option seems the be the one that will "search all fields and match any" When I open up find the " look in" box says RT-Query but it is grey and nothing can be changed. In the "Match" box it says "whole field"..even though in the options I selectet to Match Any.

    Could it have anything to do with what has the focus? (not that I know exactly what that means) but when a form opens up in 2000 are there things that run in the back that didn't in 97. I noticed in the status bar the word calculating..... is there for about 5 seconds before everything is ready to start working.

    Thanks,
    Linda

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Find feature in 2000 (Access 2000 SR-1)

    Are you converting to 2000, or did you choose the option to open it in 97 format? If the latter, the default setting won't stick. Otherwise there is something strange going on - I presume you are working on a form, and not at the table level. Have you tried doing a "Find" on a table?
    Wendell

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

    Re: Find feature in 2000 (Access 2000 SR-1)

    Try the following two things - they may make your database a bit faster.
    <UL><LI>With the database open, select Tools | Options... and clear the Automatically Update Names check box in the General tab. This is a source of problems.
    <LI>Select Tools | Database Utilities | Compact and Repair...[/list]And have you tried whether it makes a difference in which control you click before you try to search?

  6. #6
    New Lounger
    Join Date
    May 2003
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find feature in 2000 (Access 2000 SR-1)

    Thanks, Hans. I work on Thursday and will check into your suggestions. We have figured out to open up find/type the name/move the find dialoge box to the side, click in the name field and then it works. The sequence is strange and with 97 they could just start typing anything in the find box.....room number, last name, first name and it looked at all fields and any part. It was a lot faster. They are adapting ok though. Again, I'll try your suggestions Thursday or Friday and let you know.

    Linda

  7. #7
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Find feature in 2000 (Access 2000 SR-1)

    You could also try setting the default find /replace behaviour in code.

    In the onload event for the first form that opens (your main menu if you have one) put this line:

    <pre> Application.SetOption "Default Find/Replace Behavior", 1</pre>

    Regards
    John



  8. #8
    2 Star Lounger
    Join Date
    Dec 2001
    Location
    Franklin, North Carolina, USA
    Posts
    124
    Thanks
    0
    Thanked 2 Times in 1 Post

    Re: Find feature in 2000 (Access 2000 SR-1)

    Thanks, Hans. I've been blessing 2000 for this difference as well. I reset the Tools/Options Edit/Find tab to General Search. At first it didn't work. I closed the form to go into the table and try the search there, as you suggested. In the table, Find gives the "Look In" option of choosing the field or the table. Choosing the field searches only there. Choosing the table searches all fields. I wish I had those same choices in the form view.

    After playing with the table and closing it, I reopened the form and tried again. It worked. So I guess one has to make the Options change, close, and reopen.

    I am not finding an "Automatically Update Names" checkbox on the General tab or anywhere else. Is this only in 97 and not in 2000?
    Kris

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

    Re: Find feature in 2000 (Access 2000 SR-1)

    <hr>I am not finding an "Automatically Update Names" checkbox on the General tab or anywhere else. Is this only in 97 and not in 2000?<hr>
    It certainly does NOT exist in Access 97. I thought this feature was introduced in Access 2000, but it might be worded slightly differently. I am not sure about this, as I am using foreign language versions of Access 97 and Access 2002; I have never used Access 2000. Perhaps someone with an English language version of Access 2000 can react.

  10. #10
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find feature in 2000 (Access 2000 SR-1)

    I think Hans wants you to uncheck the Name AutoCorrect options
    Attached Images Attached Images

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

    Re: Find feature in 2000 (Access 2000 SR-1)

    Thank you very much, that's what I meant.

    (I have translations for all the menu options in the Office apps, but not for the zillion captions in dialog boxes)

  12. #12
    2 Star Lounger
    Join Date
    Dec 2001
    Location
    Franklin, North Carolina, USA
    Posts
    124
    Thanks
    0
    Thanked 2 Times in 1 Post

    Re: Find feature in 2000 (Access 2000 SR-1)

    Ah, I see it is already unchecked. But, as Help says, that is because I converted from 97 a year or so ago. Worth looking at! I cause enough of my own problems without the assistance of checkboxes. Thanks again. <img src=/S/notmyfault.gif border=0 alt=notmyfault width=15 height=15>
    Kris

Posting Permissions

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