Receiving errors macro errors for reports that don't exist anymore!

[nishantd]

Could someone shed light as to why the following occurs upon opening my Access project (SQL Server as the backend):

Error received: "Module not found."
If I try to save the project, but then I receive an error message that tells me it cannot find a report (which doesn't exist anymore). In addition, I get the same error message for another report which doesn't exist anymore. The error for these are below:

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

Is there somewhere I need to remove the report name from other than deleting it from the reports tab in the Access Project???

boggled...

Thanks,
Nishant

 

[___]

Do you have an Autoexec macro? If so, what's in it?

 

[nishantd]

I do not have an autoexec macro. I actually have no macros in this project what so ever (so it claims by going to Tools > Macros in the Visual Basic editor).

Thank you,
Nishant

 

[___]

There is probably some code in the OnLoad or OnOpen event of your startup form. Have a look in there.

HTH

 

[nishantd]

Here's the odd thing. In my OnLoad, I have one statement: DoCmd.Maximize. I commented it out, still get the same macro errors. Here's the other thing, I sent this Access project file to another computer and it works fine. No errors upon opening like I am receiving right now.

Very odd indeed. I assume it has something to do with the reports that were created. I don't believe that the reports stay on the SQL server (they should stay locally within the project file like the forms).

sigh,
Thank you,
Nishant

 

[nishantd]

HTH,

Sorry, I removed the other post from Modules & VBA. I wasn't sure which forum this thread would go under and failed to remove it from the other board.

thanks,
Nishant