What can I do when I can't open a from in Access?

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

Guest

I modified a form in access using VBA and then the whole program crashed.
Now if I click on the form icon in the database window nothing happens,
neither can I view it in design view, and if I click on a button that should
open the form I get the message "you cancelled the previous operation". What
can i do to get my form back?
 
I modified a form in access using VBA and then the whole program crashed.
Now if I click on the form icon in the database window nothing happens,
neither can I view it in design view, and if I click on a button that should
open the form I get the message "you cancelled the previous operation". What
can i do to get my form back?
Click to expand...

The best thing to do is to create a blank database and import all of
your objects into the new database.

File > Get External Data> Import> (Select the corrupt database)>
Import Objects (Select All from all the tabs)> Click Ok.

After completing these steps try opening the form in the newly created
database.
 
Hi, tried your suggestion - it will copy everything but that one form! Any
other thoughts?
I also tired opening in Access 2007 and got the message "There isn't enough
disk space or memory"
 
You can get the message you quoted when there is a syntax error in a query or
DLookUp that is buried in some other subroutine or feature. Check the query
that the form is bound to. Check out any modules you might be calling in the
open or load events of the form. One of your controls may have a function
with a syntax error.

I have never seen a form that would not open in design mode. You should
still be able to open the VBA module and put a debugger stop in the open and
load events, it they exist.

When all else fails, erase the errant form and start over. This is why I
make copies of my work frequently. So I won't lose more than a few hours of
work when I do something really stupid.
 
it will copy everything but that one form!

Restore that form from your most recent backup or rebuild it from scratch.
That version of that form is hosed.
 
Back
Top