Corrupt form

[houseofturner]

I have a form with quite a lot of code connected to it which has become corrupt. If I open it in either normal view or design view it crashes. I have tried repairing the database. Any other ideas about how I can get at the code to create a new form.

 

[cyanidem]

Can you open only VBA editor without opening form first? Alt+F11
Or import form to new blank db?

 

[Grumm]

Best solution should be to take a backup where you didn't had this problem.

From what I heard on the internet, it can help to save the project as access 2002/2003 database. Then convert that database back to the original version.
Some just make a new form and copy all the code and fields one by one...

 

[gemma-the-husky]

I get that sometimes. Often I get it when copying a control without a label, perhaps, or copying a label multiple times.

I save old versions of my database, so I can reload the original form.

If I keep getting issues, I save stages of development.

form1_stage1
form1_stage2
form1_stage3
form1_stage4

until I get a working final copy.

sometimes, I end up creating a new form, and copying the design elements into it. I think maybe access gets confused by managing a design with lots of design elements being added and deleted.

The main thing is to have backups available.

 

[Galaxiom]

Try a decompile.

https://social.msdn.microsoft.com/F...740ff/decompile-steps-for-mdb?forum=accessdev