In Access 2007 why does info disappear?

S

smprice

After making an entry and moving to next line the data disappears from the
previous line. I have to save and close database. When I reopen the data is
there.
Does anyone know why? Also, sometimes the data entry is nothing but XXXXX's.
 
J

John W. Vinson

After making an entry and moving to next line the data disappears from the
previous line. I have to save and close database. When I reopen the data is
there.
Does anyone know why? Also, sometimes the data entry is nothing but XXXXX's.
Click to expand...

More info please. Are you using a Form, or the table datasheet? Do you have a
Filter set on the form (or table), and if so does the data you're entering
pass the filter? Are you sure it isn't just scrolling up offscreen? What's the
datatype of the fields in which you're entering, and just what do you mean by
"the data entry is nothing but XXXXXX" - in all fields, selected fields?
 
S

smprice

I am using a table datasheet. I did not set a filter. You must realize I
know very little about Access. This was thrown on my desk to learn. I know
that it was not caused by scrolling. For example: record #1 I entered an
employee's name and a general contractors name. I then arrowed to record #2.
As I was entering the next employee name the first record disappeard. If I
save and close and then reopen the first record reappears. On occasions when
I save, close and reopen the data in all columns is nothing but XXXXXXXXXX's.
I appreciate anything you have to offer.
 
J

John W. Vinson

I am using a table datasheet. I did not set a filter. You must realize I
know very little about Access. This was thrown on my desk to learn. I know
that it was not caused by scrolling. For example: record #1 I entered an
employee's name and a general contractors name. I then arrowed to record #2.
As I was entering the next employee name the first record disappeard. If I
save and close and then reopen the first record reappears. On occasions when
I save, close and reopen the data in all columns is nothing but XXXXXXXXXX's.
I appreciate anything you have to offer.
Click to expand...

Well, at this point, nothing but sympathy and perplexity! I have NEVER seen
this happen. A2007 comes with a sample database named Northwind - perhaps you
could open it and see if you're seeing the same sort of behavior. Another
thing to try is to click the Office button (the big round "pizza" button in
the corner) and find the "compact and repair" command (again, I don't have
2007 so I'm not sure where they put it).
 
G

gls858

John said:
Well, at this point, nothing but sympathy and perplexity! I have NEVER seen
this happen. A2007 comes with a sample database named Northwind - perhaps you
could open it and see if you're seeing the same sort of behavior. Another
thing to try is to click the Office button (the big round "pizza" button in
the corner) and find the "compact and repair" command (again, I don't have
2007 so I'm not sure where they put it).
Click to expand...

After clicking the "button" select manage then compact and repair. I
always make a copy before I do this just in case. One question would be
is where are you entering this data? Directly into a table (big no no)
or a form. Some forms only show the line of data being entered. Now
the xxxxx thing that kind of weird. If I were you I'd make sure to
backup this file on a regular basis.

gls858
 
S

suzan consemulderGoemaat

smprice said:
After making an entry and moving to next line the data disappears from the
previous line. I have to save and close database. When I reopen the data
is
there.
Does anyone know why? Also, sometimes the data entry is nothing but
XXXXX's.
Click to expand...
 
E

Evi

Are you using a form. Inn Design View, click on Properties for the Form,
click on the Data tab and see if Data Entry is set to Yes. If it is, set it
to no.
Evi
 
Top