WHAT HAVE I DONE?!?!?

  • Thread starter Thread starter Courtney
  • Start date Start date
C

Courtney

I have somehow managed to delete records so that I can now no longer create a
new record in my form or in my table.

Please can someone tell me how I can un-do what I've done so I can continue
to use these forms I've taken so much time creating?? I can provide more
information about this problem I'm having if I haven't provided enough.

Thanks in advance!!
 
Hi Courtney,

I am not sure what happened unless the database is corrupted. However, you
can do anything about the records you already deleted but try to import
everything into a newly created database. Just create a new file and import
everything from your current one to the new one and it should be ok. If not,
I don't know how you would fix it.

Hope this helps!
 
What error message are you getting? Are you having the same problem when
entering data through a form or directly into a table?
 
I have somehow managed to delete records so that I can now no longer create a
new record in my form or in my table.

Please can someone tell me how I can un-do what I've done so I can continue
to use these forms I've taken so much time creating?? I can provide more
information about this problem I'm having if I haven't provided enough.

Thanks in advance!!
Click to expand...

Since you don't say what you did to cause this change, nor anything about the
structure of your form or your table, it's a bit hard to answer!

If you look at the table, not using the form, is the data there?
Open the Form in design view, and take a look at its Recordsource property.
What's there? If it's a Query click on the ... icon by it, and see if you can
open the Query as a datasheet. Does it have a blank new record line indicating
that it can be updated? If not, open the query in SQL view and post the SQL
here.
 
I appreciate all of the responses you all have given me. Miraculously, the
problem has resolved itself. I'm not sure what happened or why it is now not
happening, but I thank you for your assistance.
 
Back
Top