Dan Waters
df.waters at comcast.net
Tue Jan 18 14:00:27 CST 2011
Jim - what do you do after that to find unreferenced items? -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Tuesday, January 18, 2011 1:21 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Finding and Fixing Unused Variables, Parameters,Procedures 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com