Form trouble

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

Guest

Hi,

I have this form that, when I open it using code or otherwise, doesn't
display and keeps Access from responding. The only way to get out of it is
running:

myForm.Visible = False

From the VBA direct window.
I have tried decompiling, repairing but nothing seems to work. Any ideas?
 
Suggested sequence:

1. Make a backup copy of your database while it is not running, so you get
multiple chances to fix it.

2. Make sure the Name AutoCorrect boxes are unchecked under:
Tools | Options | General
Explanation of why:
http://allenbrowne.com/bug-03.html
Then compact the database to get rid of this junk:
Tools | Database Utilities | Compact

3. Open the form's module, select all the text, copy to clipboard, and save
in a text file on your disk. Then close the VBA window, and set the form's
HasModule property to No. Save. Close. Then compact the database.

4. After the compact, open the Immediate Window (Ctrl+G), and enter
something like this:
SaveAsText acForm, "Form1", "C;\Form1.txt"
replacing "Form1" with the name of your form.
Delete the form.
Compact the database.
Compact again.

5. Import the form by entering this in the Immediate window:
LoadFromText acForm, "Form1", "C;\Form1.txt"
Test that the form opens normally.

6. Open the form's module, and paste in the text you saved at step 2.
 
Back
Top