Tiffany said:
More info on this problem: This error will not allow me
to view or even delete any of my modules and will not
allow me to delete the combo box with the faulty coding,
my database crashes. What can i do to disable the module
itself? I get Dr Watson when i try to delete the module,
so that won't work.
I don't want to lose my whole form over this one problem.
Thanks again!
Tiffany
Before anything else, make a backup copy of your database. Heck, make
two, and be sure the database isn't open when you make them.
Now, try decompiling your database. On the task bar, click Start ->
Run..., and in the "Open:" box enter
msaccess "<path to your database>" /decompile
You may or may not have to prefix "msaccess" with the path to
msaccess.exe on your system. I find that I don't have to.
If you're using Access 2000 or later, your database will open, but there
may be no sign that your database has been decompiled. Then on the
Access menu bar, click Tools -> Database Utilities -> Compact and Repair
Database ... When the compacted database reopens, go into the VB Editor
and click Debug -> Compile, then save the project, then go back to the
application window and compact it again.
Now see if the problem is gone. My fingers are crossed.
