Visual Basic error - corrupt project

[Bob]

I've been battling an annoyance for months. It's been my personal
annoyance, since the database (Access 97 database using Access 2002)
has resided on my own workstation. Now it will be going on a file
server and others will be using it, so I'd really like to clear this
up!

A few years back I was messing with Visual Basic and created a few
form and report objects. Never quite got the hang of it. Last Spring
I was "cleaning up" and deleted quite a few queries, forms, and
reports that were no longer needed. Forgot all about the VB project
I'd tinkered with. Ever since, whenever I open the database a Visual
Basic error pops up reporting a missing form. The dialogue won't let
me NOT continue loading the project. If I say "yes, continue loading
the project" there is no problem until the next time I open the
database. If I wait for the error, all is well. If I open an object
BEFORE the error pops up, I have to click through a long series of
additional error messages telling me all these forms and reports are
"missing or mis-spelled."

I can view the Objects in the VBE Project Browser, but the option to
remove them is disabled.

It's fairly apparent how I messed up. Dozens of searches in the KB
led me to dozens of fruitless attempts to solve this. It would be
most awesome if one post here resulted in a solution (even if it isn't
pretty)!

Thanks for your attention!

-Bob

 

[Larry Daugherty]

Hi Bob,

First, look in the obvious places: startup options and in macros. If that
doesn't get it, I'd download Rick Fisher's Find and Replace from
www.rickworld.com and search your application for the named form.

HTH

 

[Bob]

Thanks for the link, that is an awesome tool! Unfortunately it didn't
turn up references to any of these missing objects. (It did turn up
quite a few references to no-longer-existing objects, but not the ones
Visual Basic is gagging on.

Why do you suppose the "Remove" option is disabled for these objects?
Where are these references hiding, and how can I remove them? ARGHH!

-Bob