[AccessD] Finding and Fixing Unused Variables, Parameters, Procedures

I was just doing that today.  You have to rerun it over and over however until it no longer finds 
unreferenced items.

Deleting an unreferenced item may make some other item unreferenced since it used to be referenced 
in the item you just deleted.

John W. Colby
www.ColbyConsulting.com

On 1/18/2011 2:20 PM, Jim Dettman wrote:
>
> FWIW, those that have Rick Fisher's Find and Replace, there is also a cross
> reference utility in there that works against all objects (not just code).
>
>   Click the Cross-Ref button and then check "Only list unreferenced items"
> under the report grouping.
>
>   One of the fastest ways to clean up an Access app...
>
> Jim.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
> Sent: Tuesday, January 18, 2011 11:19 AM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] Finding and Fixing Unused Variables, Parameters,
> Procedures
>
> This is another great time-saver in MZ Tools (VB6 version):
>
>
>
>> From the MZ Tools toolbar push the Other Utilities button.  Select 'Review
> Source Code'.  In the window that appears, you'll see a collapsible
> hierarchical listing of objects with a description of what's not used in
> blue text.  Double-click on the blue text to move directly to the variable,
> parameter, or procedure so you can fix it then and there!
>
>
>
> There is also a version of MZ Tools for .Net developers - not free but
> undoubtedly well worth it.
>
>
>
> Dan
>
>
>
>
>