Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Ohio - USA, Ohio, USA
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Lost Records? (Acces XP)

    I have a client database, and once I add or modify a record, I have a client sheet that I print and attach to the inside of our files. Recently (as near as I can determine, it was after we networked our two computers), I use the find feature to search for a record (which I know I already added) and it's not there! I then have to pull the file, pull the client sheet and re-enter everything for that record.

    Does anyone know what could cause this?

    Thanks <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

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

    Re: Lost Records? (Acces XP)

    Have you tried checking the underlying table immediately after adding or modifying a record to see if the changes are "physically" present?

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

    Re: Lost Records? (Acces XP)

    Are you searching for a record you *just* entered, or one that was entered some time ago?
    Charlotte

  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Ohio - USA, Ohio, USA
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lost Records? (Acces XP)

    Charlotte, these are records entered in the past.

    Hans, good suggestion, I'll try it. I got to thinking that perhaps when I add a single record, it is not being saved (?) perhaps because I'm hitting the exit control on the data entry form. If so, I guess it's a bad habit I got into (expediancy at the risk of accuracy?).

    Thanks

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

    Re: Lost Records? (Acces XP)

    In general, hitting the exit control on a form should still cause the record to be stored - unless your form is an unbound form. Access saves records when the form is closed unless code running behind the form does a cancel. If the record isn't there at the table, in all probability something else is going on. I'm most curious what you find, so please let us know. Thanks.
    Wendell

Posting Permissions

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