Link to home
Start Free TrialLog in
Avatar of Todd West
Todd WestFlag for United States of America

asked on

Form Load Error

I was working on an Access form in design mode when Access locked up.  I has to exit Access and when I attempted to reopen the database I received an error message, see attached screenshot.User generated image
Does anyone know how I can open my form, unfortunately I had made several changes since mt last save,
ASKER CERTIFIED SOLUTION
Avatar of Daniel Pineault
Daniel Pineault

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Todd West

ASKER

Amazing!!! Thank you so much, you are a life saver,
Avatar of Daniel Pineault
Daniel Pineault

That's called the 'Shift bypass' and it opens Access without executing any startup form, AutoExec macro..., so open without running anything.
Correction, the Access database opens but I still get the error when trying to open the form.  Any other suggestions I could try?
You still need to edit the form and isolate the issue.  It is possible that since it crashed, that the form is now corrupted and may need to be recreated.

You could comment out all the code and see if it will load or not, then gradually add the code back, ... until you can find the issue.
first step would be to backup the database, log out and make a copy.

2.  Then open it back up with shift-bypass

3.  Then perform a compact and repair

4.  Then attempt to compile the application and resolve any compile errors

5.  Attempt to open your form again.