Form will not open

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ken - 29 Mar 2008 19:32 GMT

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.

Reply to this Message

Allan V. Pimble - 29 Mar 2008 20:11 GMT

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.

> 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
[quoted text clipped - 4 lines]
> I have a lot of forms and I really do not want to have to re-create the
> database - any help would be appreciated.

Reply to this Message

Ken - 30 Mar 2008 02:07 GMT

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.

> This is sometimes caused by a temporary form that was created by Access in
> the background, and was not deleted.
[quoted text clipped - 17 lines]
> > I have a lot of forms and I really do not want to have to re-create the
> > database - any help would be appreciated.

Reply to this Message

John W. Vinson - 30 Mar 2008 02:29 GMT

>Hi Allen,
>
[quoted text clipped - 5 lines]
>
>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.

Signature

John W. Vinson [MVP]

Reply to this Message

Ken - 30 Mar 2008 04:25 GMT

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.

> >Hi Allen,
> >
[quoted text clipped - 10 lines]
> might be some erroneous records in the system tables, and this rather drastic
> expidient will give you a clean new set thereof.

Reply to this Message