Form won't open

B

Bdavis

For some reason, I've been having a lot crashing while working on this form.
The last seemed to really mess it up. I can't open it any view. Clicking on
it or clicking on design does nothing... no error message.. nothing. Also no
effect using Compact and Repair.

MS Access 2003. ANy ideas?
 
A

Allen Browne

The crashes will corrupt your database, and the form is probably beyond help
now. Do you have an old copy of the database you could import this form
from?

Suggested sequence:

1. Create a new database.

2. Turn off the Name AutoCorrect check boxes under:
Tools | Options | General.

3. Import (File | Get External | Import) the tables, or link them (File |
Get External | Link) if the database is split.

4. Import the other objects (queries, forms, reports, macros, modules)
except the bad form.

5. Import the problem form from a backup.

6. Close Access. Decompile the database by entering something like this at
the command prompt while Access is not running. It is all one line, and
include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

7. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html

8. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

For suggestions on how to stop the corruption recurring, work through the
list of items in:
Preventing Corruption
at:
http://allenbrowne.com/ser-25.html
 
B

Bdavis

Thanks Allen.

Allen Browne said:
The crashes will corrupt your database, and the form is probably beyond help
now. Do you have an old copy of the database you could import this form
from?

Suggested sequence:

1. Create a new database.

2. Turn off the Name AutoCorrect check boxes under:
Tools | Options | General.

3. Import (File | Get External | Import) the tables, or link them (File |
Get External | Link) if the database is split.

4. Import the other objects (queries, forms, reports, macros, modules)
except the bad form.

5. Import the problem form from a backup.

6. Close Access. Decompile the database by entering something like this at
the command prompt while Access is not running. It is all one line, and
include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

7. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html

8. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

For suggestions on how to stop the corruption recurring, work through the
list of items in:
Preventing Corruption
at:
http://allenbrowne.com/ser-25.html
Click to expand...
 
M

Melanie

Same problem here. Is there no way of "fixing" the defective form? I've
worked on it for hours. It would suck if it was lost! I'm ashamed to say I
don't have a backup!

Also, there is one form I am able to open and edit, but I can't print it. I
click on the Print... menu and nothing happens.
 
Top