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

jwcolby jwcolby at colbyconsulting.com
Tue Jan 18 15:35:53 CST 2011


What I have never been able to figure out is how to get a list of the unreferenced objects to allow 
me to programmatically delete them.

John W. Colby
www.ColbyConsulting.com

On 1/18/2011 4:19 PM, jwcolby wrote:
> 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
>>
>>
>>
>>
>>



More information about the AccessD mailing list