Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

"the search key was not found in any record"

Discussion in 'Information Technology' started by bird lover, Jul 28, 2006.

  1. bird lover

    bird lover
    Expand Collapse
    Guest

    I use access 2000, in an xp professional environment. Something happened to
    a record so now I get straggles where the last and first name fields were. I
    want to delete the record, but I get a popup stating "the search key was not
    found in any record."

    Any solutions. I am not a programmer
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Indian American Couple Donates For Sikh, Punjabi Culture Research In US Breaking News Aug 19, 2016
    Soul Search By Swarn Singh Bains Book Reviews & Editorials May 25, 2016
    Harpal Singh Kumar Cancer Researcher Knighted By Queen Elizabeth II Sikh Personalities Jan 5, 2016
    Movies Ashdoc's Movie Review---dozakh In Search Of Heaven ( 2015 ) Theatre, Movies & Cinema Apr 6, 2015
    Research Shows NFL Quarterbacks Play Better With Beards Business, Lifestyle & Leisure Nov 23, 2014

  3. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    bird lover <bird lover@discussions.microsoft.com> wrote:

    >I use access 2000, in an xp professional environment. Something happened to
    >a record so now I get straggles where the last and first name fields were. I
    >want to delete the record, but I get a popup stating "the search key was not
    >found in any record."


    You will need to copy all the records from before this record to
    another table. Then copy all the records after this record to the
    same table.

    Cut and paste or append queries should work.

    Then delete the old table and relationships, rename the new table and
    setup the relationships again.

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     

Share This Page