Cannot Delete MS Office Access Class Objects

[EarlCPhillips]

I copied an Access .mdb application that has worked for years to build a new
application. The old application contains a reference to a non-existant form
that I have never have been able to delete, but it has never interferred with
compiling the existing application. After I stripped out the parts I did not
need, I tried to compile the new application and I get the message "The form
name 'frmAlt1Activity' is misspelled or refers to a form that doesn't exist."
I don't know how to delete the missing Class Object or render it moot. Any
ideas?

EarlCPhillips
Ex-mainframer Learning Access to Help
Harvesters Community Food Network Feed the
Hungry Efficiently

 

[Pete D.]

Go to basics, make a new file, import everything except problem form.

 

[Bill Mosca]

Compacting might fix that, But I'd take a look at all the forms to see if
one has a subform by that name.

If you don't find anything, create a form with that name, compact and then
delete the form.

If nothing above works, make a backup copy. If you have a startup form,
change the startup form to (none) and open the database with the /decompile
switch from the Run command line.
"C:\Program Files\Microsoft Office\Office11\msaccess.exe" /decompile
"C:\MyFolder\MyDatabase.mdb"

 

[protección familia]

Compacting might fix that, But I'd take a look at all the forms to see if
one has a subform by that name.

If you don't find anything, create a form with that name, compact and then
delete the form.

If nothing above works, make a backup copy. If you have a startup form,
change the startup form to (none) and open the database with the
/decompile switch from the Run command line.
"C:\Program Files\Microsoft Office\Office11\msaccess.exe" /decompile
"C:\MyFolder\MyDatabase.mdb"

--
Bill Mosca, MS Access MVP
http://www.thatlldoit.com
http://mvp.support.microsoft.com/profile/Bill.Mosca
http://tech.groups.yahoo.com/group/MS_Access_Professionals