Empty form name and orphaned module with no Form_ prefix

[JBMoorpark]

I've just run into a problem in Access 2010 adp project that I've never seen before. I was copying a form and renaming it. The rename failed. I was attempting to rename it "frmEnterPortfolioID". It appears that the form was created with no name at all and the VBA class was created without the "Form_" prefix.

Here are the symptoms: I continually receive error messages that "The form name '' is misspelled or refers to a form that doesn't exist". I don't see an unnamed form in the Navigation Pane. I can see the form module that was created as "frmEnterPortfolioID" (rather than "Form_frmEnterPortfolioID") but I can't delete it -- the Remove option is grayed out. I can't compile the code. I can't save the project. I just get a string of the misspelled form name error messages.



Any suggestions on how to proceed would be greatly appreciated.

James

[rpeare]

In your access window right click the object window, select navigation options, check the box SHOW SYSTEM OBJECTS.

This will show you hidden system tables. from here BE VERY CAREFUL. Messing around with these tables can be extremely dangerous to your database so make a backup just in case:

Look at the table MySysObjects

This table will show you all the objects that are defined in your database. The NAME column is where you'll find your table, query, report, etc names. That's a starting point to see if you've got a corrupt object name (assuming compact/repair didn't work for you).

[alcapps]

you can also try. open a blank database and import all the objects from the offending database. Select all objects by grouping (tables, query, form, reports, modules) select all each time. If there is a problem importing the form it will tell you. Also if it accepts the form you'll know what the name is then.

hope this helps.