Help please - serious error (1 Viewer)

[BigMr.C]

I have a company database written in Access 2003.
Recently every time I try to program something or change something in it I get:

The report name "MonthlyStock" you entered in either the property sheet or macro is misspelled or refers to a report that doesn't exist.

I had a report named MonthlyStock a few weeks ago but it was deleted, in the form that called the report the reference to it was deleted as well.
I've searched the database and there's no record in any of the code of any reference to this report.

I think it might be to do with tools/options/general/Name AutoCorrect.

I had this turned on for a month or so (can't remember why). I've now turned it off but I'm still getting the above message every time I try to do anything at all in the database.

Please help this is a company database and this error is causing chaos.

thanks

 

[The_Doc_Man]

OK, what it is telling you is that a macro is trying to open the deleted report or some other item is trying to open the report. The "some other item" is using the same kind of reference that a macro would use.

Therefore, despite your attempt to scrub the DB of this pesky reference, you have not done so quite yet.

Places to look:

VBA code that drives a switchboard.
Any macro that drives a report-to-printer process.
Any form or report that has a child report on it.
A startup form/report.
A button on a form that was set up by a wizard to print a report.