Form won't open

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

Guest

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?
 
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
 
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...
 
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.
 
Same Issue, not corrupted

Hi, I have the same problem here, except that my data is not corrupted (I'm 99% certain anyway). This has happened before and the problem just fixed itself, which I wouldn't think it could do if corruption were the problem. I tried all of the solutions I could find and seemeingly nothing worked, but then they just opened fine one day. It's interesting that the problem applies to almost all of the forms on any copy/backup of the database here at work. However, if I transfer one of the databases to home, I can open the forms just fine. Seems like that would that suggest it's Access rather than the database itself? I'm fresh out of ideas, any help would be appreciated.
Thanks,
Chris
 
Back
Top