Error: There are no registered wizards of this type...

[Telecom]

In Microsoft Access 2000 I'm getting the following error message when I click on visual basic Event Procedure for the first time.

"There are no registered wizards of this type."
"Rerun Microsoft Access or Microsoft Office Setup to reinstall the wizards. If you want to preserve your security or custom settings, back up the 'workgrp file name here' workgroup information file.
For more information on backing up files, search the Microsoft Windows Help Index for 'backing up files'."

After I click OK on the error it goes back to Access. If I click the event procedure again visual basic opens up though VB the screen isn't what it suppose to be. The Object and Procedure pull downs at the top of the page disappear behind my toolbars and I can't get it to setup correctly. If I try to maneuver them correctly they still don't line up. This error seems to be messing that screen up.

This is only happening in one of my databases. In my other database the Object and Procedure pull downs at the top of the page are coming up correctly. If I start a new database that works fine too. I'm not sure why its doing it only on this database

I'm worried my VB is corrupted. Looking for any insight on what caused this and how to fix this.

Thanks!

 

[RuralGuy]

I would back up the mdb now and perform *all* of the suggestions offered here asap.

 

[Telecom]

I took all my forms, tables, reports, queries, etc and moved them into a new database. I had no problem last night after that. I logged back into my new database this morning and the error came back up.

I tried doing a repair on Microsoft Office off my Control Panel, which didn’t work.

Next I removed the latest VB code I was working on behind my form. I compiled the VB and saved the database. I exited the database and came back into it. I received no error this time. I re-added the code back in, compiled, saved the database, and exited the database. I come back into the database and no errors.

I did have some issues with that specific code so I’m working on correcting it. So I’ve got my fingers crossed that it doesn’t happen again once I debug that code.

Thanks for your help.

 

[RuralGuy]

I guess that's good news. Thanks for posting back. You *do* have Name Auto-Correct turned off don't you? Tools>Options>General tab. I also run with Compact on Close on during development. I keep a "/decompile" shortcut handy and run it every so often.

 

[Telecom]

I just checked and I did have Name AutoCorrect - perform name AutoCorrect checked. I just removed it.

Good idea on the compact on close for your development/design database. I'll do the same.

 

[Telecom]

For those that curious or for those that got this error I have figured out why it occurs…

The errors occurs in the following conditions:
1. In Visual Basic under Access Forms.
2. If you select a line of code in a non-private module with 'Toggle Breakpoint'. (Highlighted red)
3. Save the form.
4. If you leave Access with that breakpoint intact.
5. Doesn't matter if you compact and repair the Database.

Once you press ‘Event Procedure’ under a form to back into Visual Basic you’ll get that error. If you try to clear the breakpoint access will crash. You have to select a portion of code around that breakpoint or the whole access form code and delete it and paste it immediately back in. The breakpoint will clear. Compile and save the form.

*It doesn't occur in private modules underneath the Access Forms.

I tested it multiple times and go the same results.

Good luck!