Can't open important form

[smardonl]

I am developing a database that requires a master data entry sheet. Recently, I have been unable to open the data entry sheet using any technique I can think of. Also, I cannot close the entire application because access cannot save the project. The following error message is displayed on trying to close the application: "The form name 'form 1' is mispelled or refers to a form that does not exist". I will continue to search for anything in reference to 'form 1', but have not been successful so far. If anyone has any suggestions to solve these problems, please help.


Thanks,
L

 

[mdmilner]

I don't know - haven't encountered that precise problem before.

My troubleshooting guesses are:
Can you open the data entry sheet in design mode?
Can you view the source table for the data entry sheet?
Does it have a source table or does it pass values elsewhere?
Can you rebuild the data entry sheet and have that work?

On saving
Is there any chance you're saving to a full drive?
Could you have a hidden/non-visible form open?
(Possibly something that opens with the db but is set .Visible = False)
and - could that form have events being triggered by closing?

Did you ever use "form 1" anywhere for anything? Even temporarily?
Have you tried something like this to list your query objects?
Could you be attempting to open a form that was originally a subform of something else (that doesn't exist anymore)

     Dim db As Database
     Dim qry As QueryDef

     Set db = CurrentDb()

     For Each qry In db.QueryDefs
        Debug.Print qry.Name
     Next qry

Something like this would allow you to list all your forms:

          For i = 0 To db.Containers("Forms").Documents.Count - 1
                 debug.Print db.Containers("Forms").Documents(i).Name
               End If
          Next i

I'm wondering if maybe you should be looking for a child/master relationship between recordsources or a subform reference.


Mike

 

[smardonl]

Mike,
Thanks for all the suggestions. I will spend some time exploring all the options and post back when I resolve.

L

 

[mdmilner]

Hope that helps but I could be totally out in left field.

Could just be a corrupted database, in which case you might need to try to export as many of the objects and code to a 'fresh' database copy that you can until trial and error shows you what is actually broken.

It's good that you can still open it and see everything else right now.

Mike