Form will not open

[Ken]

I am using Access 2003 and have a form that will no longer open. I tried to
open it in design view and still nothing. I renamed the form and it still
will not open.

I have tried to repair & compact the database with no luck.

I have a lot of forms and I really do not want to have to re-create the
database - any help would be appreciated.

 

[Allan V. Pimble]

This is sometimes caused by a temporary form that was created by Access in
the background, and was not deleted.

While in the VBA IDE check to see if you have any temporary forms listed in
the object browser. They begin with a ~. Then try this:

DoCmd.DeleteObject acForm, "~TROUBLESOMEFORM~"

~TROUBLESOMEFORM~ being the name of the actual temporary form you see in the
object browser.

I hope this helps.

 

[Ken]

Hi Allen,

There are no forms with the name of my form. The form name that will not
open is frmUnits_Annexes so I tried DoCmd.DeleteObject acForm,
"~frmUnits_Annexes~" and received an error that object does not exist.

I did not see anything in the F2 object browser.

Thanks for the suggestion.

 

[John W. Vinson]

Hi Allen,

There are no forms with the name of my form. The form name that will not
open is frmUnits_Annexes so I tried DoCmd.DeleteObject acForm,
"~frmUnits_Annexes~" and received an error that object does not exist.

I did not see anything in the F2 object browser.

Thanks for the suggestion.

It might be necessary to create a new empty database, and use File... Get
External Data... Import to import everything that you want to keep. There
might be some erroneous records in the system tables, and this rather drastic
expidient will give you a clean new set thereof.

 

[Ken]

John,

Thanks for the suggestion but it did not work completely. One of the forms
did not import, but what was interesting is that the forms that would not
open in the original database imported fine.

Thanks very much for this suggestion - I only need to re-do a small sub-form
instead of 2 very large and complicated forms.