Todd West
asked on
Form Load Error
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That's called the 'Shift bypass' and it opens Access without executing any startup form, AutoExec macro..., so open without running anything.
ASKER
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.
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.
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.
ASKER