David McAfee
davidmcafee at gmail.com
Tue Nov 9 13:21:01 CST 2010
That is so awesome! Thanks for the tip Lambert. On Tue, Nov 9, 2010 at 11:10 AM, Heenan, Lambert <Lambert.Heenan at chartisinsurance.com> wrote: > If you do the right-click inside a sub/function then it will only check that sub/function. If you do so anywhere else in a module then the whole module is checked. > > But if you use the MZ Tools tool bar, selecting 'Other Utilities' and then 'Review Source Code' (or going via the menus that would be Tools/MZ Tools/Other Utilities/Review Source Code) then the whole project is checked. > > Very handy! As is the Procedure Callers feature that lets you find routines no longer in use. > > Lambert > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee > Sent: Tuesday, November 09, 2010 1:48 PM > 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 > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >