Heenan, Lambert
Lambert.Heenan at chartisinsurance.com
Tue Nov 9 09:36:35 CST 2010
MZ Tools will do that for you. http://www.mztools.com/index.aspx Right Click anywhere in a code module and select "Review Source code" from the MZ Tools menu. Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Tuesday, November 09, 2010 9:38 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Cross Reference Utility, was RE: New engagement; trying to avoid the "tip of the iceberg" consulting trap A related questions - I am cleaning up a form which, after its cleaned will have a lot of variables DIMmed which are no longer needed. Does anyone know of a some kind of utility that will display all the variables which are no longer referenced anywhere? TIA Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Tuesday, November 09, 2010 5:03 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] New engagement; trying to avoid the "tip of the iceberg" consulting trap Rick Fishers Find and Replace....goes a long way in cleaning up a junk DB fast. Use the cross-reference utility to find all the junk that can get weeded out right away. Then go back and take care of the embedded spaces and apply a prefix. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms Sent: Monday, November 08, 2010 6:21 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] New engagement; trying to avoid the "tip of the iceberg" consulting trap So I met with the client. Not a large application, but what a mess. Spaces in the column names, no discipline in object names, etc, etc, . I could go on forever. It also has structural problems...one huge table that contains many columns that only apply to 20% of the rows. This begs for separate linked tables of course. I'm giving them a 3 man-week estimate for putting a pretty face on this pig. That's what they are really asking for.... A new menu and enhancement of the existing forms for better navigation. Oh, and much of that work will be done at home office....they have no good dev boxes there... Only these laptops with tiny, eye-tiring screens and chicklet keyboards.... And to make matters even more miserable, it's gotta stay in Access 2007. > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms > Sent: Saturday, November 06, 2010 8:36 PM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] New engagement; trying to avoid the "tip of the > iceberg" consulting trap > > Thanks all. Jim D. - based on that great rate that you are getting, > I've decided to make it a fully-paid 8 hour assessment. > After all, they're at least getting a report at the end of it. > That'll be the deliverable. > > I have no idea as to what I'm walking into with this client. > Since this engagement has been "on again", "off again", several > times.... > I don't think that's a good sign of a "stable" client. > This sort of conduct indicates in-fighting, budget problems, or other > management "issues". > I've been thru the mill over the past 2 years with IT vs. End user > politics and let me tell you, it really, really sucks. > > So after the 1 hour interview, if they don't like the "deal", I walk > out. > No charge. -- 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com