Show VBA Code on Form That Will Not Open

[Earl C Phillips]

In the initial Form_Open code there is a string that fails before the form is open, preventing me from opening the form and accessing the VBA code to correct the problem.

How can I access the VBA code to correct the problem if it otherwise prevents me from opening the form so I can access the VBA code:banghead:?

 

[pbaldy]

Can't you open the form straight to design view? Failing that, open the VBA editor (Alt-F11) and edit that form's code directly.

 

[Earl C Phillips]

When first opening the application by opening a file, I do not have the choice of opening in design view. I would happily do so if I could, but that is not a choice. Earl

 

[pbaldy]

How about if you hold down the Shift key when opening the db?

 

[Earl C Phillips]

Alt-F11 does not work either. The app has a front end password which I cannot seem to circumvent.

 

[Earl C Phillips]

I tried typing in the password, then pressing ALT+F11, then submitting the password. That worked.

 

[Earl C Phillips]

I tried typing in the password, then pressing ALT+F11, then submitting the password. That worked.

Thank you very much. I learned a valuable lesson today.

 

[pbaldy]

Glad you got it sorted out.