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