my data disappears

[Guest]

I set up this database several months ago and it worked fine. I recently
added data to a form (which already contained data) but when I reopened it
today, all data was gone from the one form. Although the AutoNumber continued
at the point I left off, I can not find the entered data. I tried entering
datat again, and after closing and reopening, again it was blank. Also, when
I try to preview reports I'd set up, I get the error message 'error executing
command'. Please HELP!

 

[Larry Daugherty]

Your data is in a table, not a form. To grossly over simplify, a form
is like a lens moving over your data.

Probably the quickest way to a workable solution is to go to
Database|Table view, select the table in question and click the
Autoform Icon on the toolbar above the main window. Go through the
steps and give your new form a name.

The new form should work? It should. If you have done some fancy
things you like on your previous form you can copy and past the
controls from one form to another. First do another copy of the new
form so that if and when something breaks you can get back to
something that works.

Once you have a working form you can analyze the difference between
forms to see why the one doesn't worn and the other does.

HTH

 

[J. Goddard]

If you are using a form to enter the data, is the Data Entry property
set to "Yes"? That will cause the behaviour you describe, where you
cannot see existing data. Change the Data Entry property to "No" to see
existing data or to add new records,

John

 

[John Spencer]

It is possible that your database has become corrupted.

What happens if you open the table that contains the data? Do you see the
data? If so, some of the things said elsewhere in this thread may apply.

Are you getting other errors?

FIRST, make a copy of your database so that you can at least recover to the
present state.

Next. check out the following for information on how to recover from
corruption

Try Allen Browne's article on Recovering from Corruption at:
http://members.iinet.net.au/~allenbrowne/ser-47.html

Also you take a look at Tony Toews site
http://www.granite.ab.ca/access/corruptmdbs.htm

 

[Guest]

Thank you - that seems to have done it!

Jean

Your data is in a table, not a form. To grossly over simplify, a form
is like a lens moving over your data.

Probably the quickest way to a workable solution is to go to
Database|Table view, select the table in question and click the
Autoform Icon on the toolbar above the main window. Go through the
steps and give your new form a name.

The new form should work? It should. If you have done some fancy
things you like on your previous form you can copy and past the
controls from one form to another. First do another copy of the new
form so that if and when something breaks you can get back to
something that works.

Once you have a working form you can analyze the difference between
forms to see why the one doesn't worn and the other does.

HTH

 

[Guest]

John, although I can see all records, some of the entries have #Name instead
of what's entered.
Jean