Rocky Smolin
rockysmolin at bchacc.com
Tue Nov 9 16:32:03 CST 2010
Wow. I HAVE mztools. Never used it though. Gus I'm gonna start. Thanks Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee Sent: Tuesday, November 09, 2010 10:48 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Cross Reference Utility, was RE: New engagement; trying to avoid the "tip of the iceberg" consulting trap I never knew this existed in MZ Tools. Does this check the whole project, or only the current module? On Tue, Nov 9, 2010 at 7:36 AM, Heenan, Lambert <Lambert.Heenan at chartisinsurance.com> wrote: > 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 > > -- > 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