can't find object

[slimjen1]

Hi all. Im working on a 2003 database I took over. On a particular form, the users are getting an error "can't find the object "some name". If "some name" is a macro or macro group, make sure you have saved it and that you have typed its name correctly.
The error happens when they type in a field or select from a drop down box. They can select ok and it would go away but comes back on the next record. I checked all the objects and macros and there is none by that particular name. I searched the modules and code through the entire project and nothing by that name. I can only guess that an object by that name did exist at one time but now deleted. Any suggestions on how to get rid of the error please. Thanks

 

[jdraw]

You could try Compact and Repair. It can often "correct" some anomalies when it removes some of the bloat/deleted info during its garbage collection activity.

Good luck.

 

[Solo712]

Hi all. Im working on a 2003 database I took over. On a particular form, the users are getting an error "can't find the object "some name". If "some name" is a macro or macro group, make sure you have saved it and that you have typed its name correctly.
The error happens when they type in a field or select from a drop down box. They can select ok and it would go away but comes back on the next record. I checked all the objects and macros and there is none by that particular name. I searched the modules and code through the entire project and nothing by that name. I can only guess that an object by that name did exist at one time but now deleted. Any suggestions on how to get rid of the error please. Thanks

Hi,
remove the field from the form and the reference to the field in the form's Row Source select query (and in any combo box it appears). That should clear the problem.

Best,
Jiri

 

[slimjen1]

I have compacted and repaired. Thanks for the suggestion. Solo; remove what field? There is no field name the error is referring to. The field and the drop down are needed on the form. Are you suggesting perhaps to remove and add back?
Thank you

 

[Solo712]

I have compacted and repaired. Thanks for the suggestion. Solo; remove what field? There is no field name the error is referring to. The field and the drop down are needed on the form. Are you suggesting perhaps to remove and add back?
Thank you

Look in the Record Source of the Form (on the Data tab of the Property Sheet). Most likely the reference was not cleaned up when the field was removed from the table.

Best,
Jiri