Question Removed form is still in VB

[April15Hater]

Hey guys-

Access is being weird again. I'm using 2003 and I removed a form (frmProductionStep5) however it is still showing up in VB. I even get an error upon opening VB:

The form name 'frmProductionStep5' is misspelled or refers to a form that doesn't exists.
If the invalid form name is a macro, an action failed dialog box will display the macro name and the macro's arguments after you click oK. Open the Macro window and enter the correct form name.

When I right click frmProductionStep5 in VB, the option to remove it is grayed out. How can I fix this problem?

Thanks,

Joe

 

[boblarson]

Perhaps you should try importing everything into a blank mdb/accdb file. That should rid yourself of "hanging chads" so-to-speak .

 

[April15Hater]

Does that have any effect on the security and MDW file?

 

[boblarson]

Does that have any effect on the security and MDW file?

Yes, it can. So this is a production database which is getting updated? If not, I would suggest not adding Access User Level Security until you are done with it.

So, as an alternative, can you post a screenshot of the VBA window to show what you are talking about?

 

[April15Hater]

So this is a production database which is getting updated?

I'm not sure what you mean by Production Database. I know I used the word production in some of my forms, but it's possible that I may have used it out of context.

 

[boblarson]

I'm not sure what you mean by Production Database. I know I used the word production in some of my forms, but it's possible that I may have used it out of context.

Production meaning it is currently in use by your users and not just in development.

I can't see the pics as photobucket is blocked at my work. Can you just upload the pics as attachments?

 

[April15Hater]

Not sure why the pics didn't show, here's a link:

http://s71.photobucket.com/albums/i145/april15hater/?action=view&current=desk1.jpg

http://s71.photobucket.com/albums/i145/april15hater/?action=view&current=desk2.jpg

 

[April15Hater]

sure thing

 

[boblarson]

Not sure why the pics didn't show, here's a link:

http://s71.photobucket.com/albums/i145/april15hater/?action=view&current=desk1.jpg

http://s71.photobucket.com/albums/i145/april15hater/?action=view&current=desk2.jpg

I still can't get to them as this location is blocked by work. Can you just attach them instead?

 

[April15Hater]

I'm adding to the front end, so this version is not really in use yet. I have a script to copy the MDE locally on every startup, and that's how I generally deploy it.

 

[boblarson]

Well I see the error message, but I was hoping for the VBA Window where you said it can't be deleted. You do realize that you have to close the error message before trying to delete anything, don't you?

 

[April15Hater]

yes, there should be 2 screen shots in there...one of the message and one of the VB

 

[April15Hater]

Lol, if that were the case, I'd hang up my hat now!

 

[boblarson]

yes, there should be 2 screen shots in there...one of the message and one of the VB

It looks like duplicates of the same shot, at least on my end.

 

[April15Hater]

Here's another showing the remove grayed out.

 

[boblarson]

Yep, I see it. If you don't have the form to be able to delete and the code still has that, about the only think I can see is to import everything into a new database file.

You would need to set up your security again, but I wouldn't do it until you are ready to deploy the database as it can be a pain. Also, be sure to turn off Name Auto Correct (which can also be affectionately known as Name Auto CORRUPT).

 

[boblarson]

Just a lark - Have you tried compacting it?

 

[April15Hater]

Yeah, that was the first thing i tried. What happened was I couldn't even get the thing to open in design mode, so at that point I did a compact and no dice. Then I figured I'd delete it and add it from a backup, and that's when this problem came up.

 

[April15Hater]

It's also probably worth noting that this file was originally 2007 MDB, then I went to 2003 MDB for the ULS.

I tried another compact and it bombarded me with error messages.

 

[boblarson]

It's also probably worth noting that this file was originally 2007 MDB, then I went to 2003 MDB for the ULS.

I tried another compact and it bombarded me with error messages.

Yeah, I think you are down to doing the import - sorry.