Ghost forms

[Ken]

I have upgraded a db from Access 97 to 2002 and when running it it complains
of missing forms.

Going back to the original 97 db; and going into VB by looking at the code
in one of the forms; I notice that in the "Microsoft Access Class Objects"
node, there are entries for the missing forms. I can right click on one of
those and select "View Object" and am taken back to Access and shown the
form. (I have a screen print showing the form, with it not being in the
forms list!). Has anyone seen this before? How can I gain access to these
ghost forms so that I can export them to the upgraded database?

 

[Allen Browne]

I presume these forms do not show in the Database window in Access 97, and
that you have already tried checking the Hidden and System check boxes
under:
Tools | Options | View

If so, the mdb may be corrupt, or they might be marked for deletion (to be
removed from the database next backup.)

Since you know the names of these objects, you could try exporting them to a
text file:
SaveAsText acForm, "Form1", "C:\Form1.txt"
If that works, you could then import them into another database with:
LoadFromText acForm, "Form1", "C:\Form1.txt"

 

[Ken]

I was not aware of the Hidden and System check boxes. Thanks greatly.

Ken