This question been asked before on this forum, There an answer that was given
by
Larry Linson
Code snippets left over from now-deleted Controls are moved into the General
category, but with their original name. They are not, therefore, difficult
to find, though you do have to open the Module Window for each Form and
Report.
Unreferenced Queries, Forms, and Reports can be found using a third-party
tool such as Speed Ferret (
http://www.moshannon.com) or Find & Replace
(
http://www.rickworld.com) to search for their names, or one of the tools in
FMS' suite (
http://www.fmsinc.com) such as Total Access Analyzer to create a
cross-reference list.
I worked on a Y2K Remediation project that used these very tools plus some
locally written Queries to clean up an older Access front-end before doing
the actual Y2K checks. We were able to remove a significant number of unused
objects and simplify the actual work of identifying items of interest in
regard to Y2K.
Be sure to retain an offline copy of the original... on one or two
occasions, someone got a little overenthusiastic and removed something that
we had to restore later!
Larry Linson
Microsoft Access MVP
