Big Problem opening form !!!

A

Ayo

I am getting this message everytime I try to open a form in my database that
I am working on. I can open every other form expect this one. What do this
mean?

"The isn't enough memory to perform this operation. Close unneeded programs
and try the operation again."
 
A

Allen Browne

The message means that this form has corrupted.

There are various ways you can try to rescue it. Firstly, make a backup copy
of the database file, so you get multiple goes at rescuing it.

If you had any code in the form's module, I suggest you open your code
window, and see if its module is there (on the Window menu.) If so, copy the
code to clipboard, and save it (e.g. in Notepad.)

Next, do a compact repair, to see if this solves it. (Unlikely, but worth a
shot.)

Next, see if you can export the form to a text file with the undocumented
SaveAsText. Open the Immediate Window (Ctrl+G), and try this kind of thing:
SaveAsText acForm, "Form1", "C:\MyFolder\Form1.txt"
If that works (i.e. you don't get an error, and the text file is in the
folder you specified), delete the bad form, and compact the database. You
can now get Access to recreate the form for you from the text file, like
this:
LoadFromText acForm, "Form1", "C:\MyFolder\Form1.txt"

If the SaveAsText generates an error, you will need to delete the form,
compact the database, and create it again. You can then paste the text you
saved in Notepad back into this new form's module instead of having to
re-write it.
 
A

Arvin Meyer [MVP]

Sometimes this is caused by opening a form with grouped controls. If the
problem continues after rebooting, try ungrouping controls in design view.
 
T

Tom van Stiphout

I would put a backup of the project back. Yours is likely corrupted.

-Tom.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top