Access Form code saved as class with no Form_ prefix

Access Discussion in 'Microsoft Office' started by JBMoorpark, Jan 21, 2013.

  1. JBMoorpark

    JBMoorpark

    Joined:
    Jan 21, 2013
    Likes Received:
    0
    I've just run into a problem with Microsoft Access (2010) that I've never seen before. I was copying and renaming a form and the rename failed. I now have an Access class that is identified as a form in VBA but doesn't show anywhere in the Navigation Pane.

    The form name was supposed to be "frmEnterPortfolioID" and should have created a class called "Form_frmEnterPortfolioID". Instead, it created just the bare name "frmEnterPortfolioID".

    I can't save the project, remove the module (the Remove option is grayed out). I've tried closing without saving and forcing a decompile, but the orphaned module still appears. I get constant error messages that say "The form name '' is misspelled or refers to a form that doesn't exist." I've tried creating a form with the same name and creating a module to go with it but the operation fails. I cannot compile the project because of the "form name misspelled" errors.

    I can see the class in VBA explorer but can't delete it. It seems like that would solve the problem if I could.

    Any suggestions?
     
    Last edited: Jan 21, 2013
    JBMoorpark, Jan 21, 2013
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.