Jim Dettman
jimdettman at verizon.net
Tue Jan 18 14:59:56 CST 2011
Yeah and select the objects you want to search through...watch it if you select all of them. On a big DB, it can take a while to cross reference everything. 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 03:32 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Finding and Fixing Unused Variables, Parameters,Procedures I got it - push Generate first! -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Tuesday, January 18, 2011 2:00 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Finding and Fixing Unused Variables, Parameters,Procedures 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. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com