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

Dan Waters df.waters at comcast.net
Tue Jan 18 15:41:28 CST 2011


When the report comes up, Select the Office Links button (has a Word icon)
and select the spreadsheet option.  From that spreadsheet you can get the
list into an Access table and it's all downhill from there!  ;-)

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, January 18, 2011 3:36 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Finding and Fixing Unused Variables,
Parameters,Procedures

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
>>
>>
>>
>>
>>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list