Results 1 to 5 of 5

Thread: Acc2000 (SR1A)

  1. #1
    doughnut
    Guest

    Acc2000 (SR1A)

    Please help, I am fairly new to the IT world, and am even newer to databases, and Access, but have been put in charge of them. My problem is that I have converted a few users from 97 to 2000. I am finding that the 'Find and Replace' feature that is built in does not return all of the values if they do a search of the whole table. It will return some records, but it is very important that it returns all of them. If I do a field search all of the correct records are returned. Please keep in mind I have not done any VB coding in this database. We are using the Find and Replace that ships with the Suite. Also it worked when we were using 97Sr2.

    Thank You for any help you may be able to provide.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Acc2000 (SR1A)

    Are you talking about using the Find dialog from an open table? That isn't normally something you allow users to do in a real application. In their own versions of databases, you can't really stop them, but what is the purpose of this replace? It sounds like a good way to destroy your data at one fell swoop.
    Charlotte

  3. #3
    doughnut
    Guest

    Re: Acc2000 (SR1A)

    I

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Acc2000 (SR1A)

    Hi,
    A couple of questions:
    1. Have any filters been applied to limit the data shown by the form?
    2. What options are the users using in the Find dialog for Match and Search? These can both restrict what data is found.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    doughnut
    Guest

    Re: Acc2000 (SR1A)

    The answer to number 1 is no. There have not been any filters placed on the data. There are only 530+ records in the table. As far as the options being placed in the find box. They are searching for any part of the word, in the table and starting at the beginning. I have tried changing things around in this area, and have not had any luck. But the same criteria used while searching only the specific field that the data resides in returns exactly what it should.

Posting Permissions

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