Forms are gone

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was working on database, editing some VB code. When I returned to access
and tried to open up one of the forms, it came up blank. So did the rest of
the forms in the database. When I open them up in design mode, they appear
exactly as I had created them. However when I simply open them they appear
blank. Any idea how to fix this problem.
 
A form will open "blank" if both (i) it's recordsource is empty and (ii)
AllowAdditions is set to "No".

If you think your database might be corrupted, your best bet would be to
create a new database and import all the objects from the old one.
 
Dave said:
I was working on database, editing some VB code. When I returned to
access and tried to open up one of the forms, it came up blank. So
did the rest of the forms in the database. When I open them up in
design mode, they appear exactly as I had created them. However when
I simply open them they appear blank. Any idea how to fix this
problem.
Click to expand...

Have you somehow set your database to be read-only? If the tables are
empty, and you can't add records, the forms will be blank.
 
Dave said:
They are not read-only
Click to expand...

Then if all you did between "working" and "not working" was edit some VB
code, and the problem persists even after you have entirely exited the
database and re-entered it, I agree with Baz that corruption might be
involved. If you were editing code while forms were open in form view,
that may have caused it. Try Baz's suggestion of creating a new
database and importing all objects from the old one, and see if that
clears it up.
 
Dave said:
They are not read-only
Click to expand...

Thye might not be *intentionally* read-only, but htat is about the only way
to get the blank form appearance. Have you tried making edits directly in
the query being used as a form RecordSource? If the query won't allow edits
then the form won't either.
 
Back
Top