Module Not Found AGAIN! (Among other things)

[RacerGirl117]

I got the above error message on my Timesheet database again this morning. Once clicking OK on the message box, it opened up the code window for a particular report so I assumed that report had become corrupt. So I created a blank database and imported everything from a backup copy except anything tied to this report. That made the "Module not found" error message go away but while attempting to fix the problem I was going through all the switchboard options and discovered that quite a few of the report buttons do not work. I get the "There was an error executing the command." message. But...when I check out the Switchboard Manager everything looks as it's supposed to be. All this from a (what I thought was) good backup copy of the database.

The "bad" reports go back as far as October of last year. These reports are strictly administrative type reports and don't get used so I'm guessing that the corruption followed the database. I've never seen a corruption affect so many different things before.

Any idea what could be causing this to happen? What causes the "Module not found" error message to occur? Anything in particular or is it just that code can become corrupt?

Any ideas as to how to repair the reports (other than deleting and recreating them)?

Your help is appreciated.

Jessica Morgan
Fire Fighter Sales & Service Co.
Pittsburgh, PA

http://www.firefighter-pgh.com

 

[RacerGirl117]

Additionally, when I attempt to open any of the "corrupt" reports I get the following message:
The Microsoft Jet database engine could not find the object "Cost Categories Report". Make sure the object exists and that you spell its name and the path name correctly.

I don't understand what this means, so some clarification would help.

Thanks in advance,

Jessica Morgan
Fire Fighter Sales & Service Co.
Pittsburgh, PA

http://www.firefighter-pgh.com

 

[Trendsetter]

Hi Jessica,
Somewhere in the population of the report there is a reference to this "Cost Categories Report" this could:
1) in the report itself as a subreport or a field with that name as the Control Source.
2) in the query that populates the report either in the tables/queries used or the references within the query.
3) in the Sorting and Grouping section with listings for the Header/footer types

Somethong in the report is looking for it and you nedd to find it to stop your troubles!!!

 

[RacerGirl117]

Trend,

I'd love to, except I can't even go into design mode of the report. Not to worry, I found a good copy from 2001 and imported it.

I'm rebuilding the Switchboard as well as that seems to be causing some grief too.

Thanks,

Jessica Morgan
Fire Fighter Sales & Service Co.
Pittsburgh, PA

http://www.firefighter-pgh.com

 

[Trendsetter]

Best of luck - if you need moral support then "we're all with you!!!!!"