Module not found problem

[Zul77]

Hi;

I'm new here. Now I'm running a Db project using access 2003. I've made a typo mistake in Vb and I got "Module not found" pop up everytime I open my form.

I've found my problem but I don't know how to delete or remove the file that cause the problem. Please review my pic attach. Thanks for your atttention.

 

[RuralGuy]

Try importing your db into a new db and see if the problem follows.

 

[ghudson]

From the VBA editor, just right click the module you circled and select to remove it and not save it as a text file.

 

[ajetrumpet]

From the VBA editor, just right click the module you circled and select to remove it and not save it as a text file.

im contemplating weather or not this was worth the attention hudson. nice job though!

 

[Zul77]

From the VBA editor, just right click the module you circled and select to remove it and not save it as a text file.

Thanks for the replies.

I have tried the option. However as you see in the pic attach, the option to remove the file is unavailabe.

I haven't try Ruralguy option yet.

The only solution that I have tried is creating a dummy form similar with that circled name. And it's work. Just want to know how to solve the problem the other ways. Thanks again for the help

 

[DCrake]

Looking at the main Access banner is reads SchoolAthletic_Backup4 this implies you are having serious problems with the database. Have you run a compact and repair also a debug.

 

[Zul77]

Thanks for your advice. Yes I have compact and repair the Db but the item still there.

 

[SOS]

I haven't try Ruralguy option yet.

The only solution that I have tried is creating a dummy form similar with that circled name. And it's work. Just want to know how to solve the problem the other ways. Thanks again for the help

Yes, the other way is to do exactly what RuralGuy said - import everything into a brand new Access shell and then it should not bring it over when you do that. That solves many corruption issues.

 

[Rabbie]

I notice that the form in question has a space character before subform. Try renaming it without any embedded space characters.

 

[Zul77]

Thanks guys..... I'm appreciate you help