none
Search keys RRS feed

  • Question

  • When I click on table new window pops-up and it says,"The search Key are not found in any fields" so I want to know what error that occur?
    Wednesday, May 1, 2019 2:36 AM

All replies

  • It sounds like corruption to me.  Do you have a backup you could restore?

    As for why, there are lots of potential causes:

    • Database being shared amongst multiple users
    • Database not split
    • Network issues
    • Using an Access database over a wireless network
    • Coding issues
    • ...

    It is usually very difficult to nail down the exact cause of such issues.


    Daniel Pineault, 2010-2018 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Wednesday, May 1, 2019 10:03 AM
  • This sometimes happens if you have an index on a memo field.

    1. open the table in design view

    2. select the memo field

    3. check if there is an index on it. If so, delete it, save the table's design and compact the database.


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Wednesday, May 1, 2019 9:03 PM
  • Hi Bill.  Nice to see you!

    Thanks for sharing that nugget of knowledge.  I did not know that!  Another one to store away in the vault because I'm sure at some point it will be very useful to be aware of.


    Daniel Pineault, 2010-2018 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Wednesday, May 1, 2019 9:25 PM
  • Hi Daniel - Always nice to hear from you. Me teaching you something!? Now that's a rare one.

    Another good reason to clear out the auto-indexing feature, huh? Who in his right mind would index a memo field?


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals


    Wednesday, May 1, 2019 9:30 PM
  • Bill, don't sell yourself short!!!

    When I started off, I was the junior and people such as yourself, Dirk, Tony, Albert (and so many more) were kind enough to spend the time to share your wealth of knowledge with me (heck, you just did it again in this thread.  I guess I still have some learning to do).  Your site held many a gems that I have learnt from, and/or inspired myself with.

    To me, you will always be one of the Access greats, and humble to boot!  I most sincerely mean this.

    Take care of yourself Bill and keep sharing.


    Daniel Pineault, 2010-2018 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Thursday, May 2, 2019 12:01 PM