Can't clear error message

Question

I'm I am currently using Access 2003 but am testing my databases for use in Access 2010.  I occasionally got the above message in 2003 but I get them a lot in 2010.  I can't figure out how to clear the error so I don't get them anymore.  They come from what I think are broken links to reports that I either renamed or deleted.  There are 3 or 4 error messages for about 7 deleted/renamed reports.  There are no macros that mention these deleted reports.

Any ideas?

Answer 1

Hi Tom - thanks for the info about Rickworld.  I downloaded the find-and-replace shareware and ran it over my db with no luck.  Darn!

The way you would use Rick Fisher's Find and Replace is to put in the report name exactly as shown in the error, make sure you click FIND ONLY checkbox and select QUERIES, FORMS, REPORTS, MACROS, and MODULES so that it will search through all of those.  Then, when done, you click on the CROSS REF button and then the report button.  It should then show you a report of everywhere that specific value is used (in this case form name).

Answer 2

Hi Tom - thanks for the info about Rickworld.  I downloaded the find-and-replace shareware and ran it over my db with no luck.  Darn!

Cindy - did you try VTools as suggested by Tom? I use that one all the time. 

Also, if you used the control wizard to create buttons to open reports, that wizard creates VBA code. Press Alt+F11 to open the code window. Then press Ctrl+F to search for that report name in the code.

Answer 3

Hi Tom - thanks for the info about Rickworld.  I downloaded the find-and-replace shareware and ran it over my db with no luck.  Darn!

Answer 4

Rick's Find and Replace should help; but I would also strongly suggest that you turn off the "Name Autocorrect" feature (known to some of us as Name Autocorrupt).

Click the Office medallion, then the Access Options button; scroll down on the Current Database tab and be sure that "Track Name AutoCorrect info" is UNchecked. Compact and repair the database and see if that doesn't clear the error.

Answer 5

Use  a good Search tool such as http://www.skrol29.com/us/vtools.php or http://www.rickworld.com/products.html to search for that name. It must be mentioned somewhere, and these tools can find it.