[AccessD] Cross Reference Utility, was RE: New engagement; trying to avoid the "tip of the iceberg" consulting trap

Dan Waters df.waters at comcast.net
Tue Nov 9 15:05:38 CST 2010


The Edit toolbar itself is pretty handy.  It contains the Comment /
Uncomment buttons, and it contains the buttons for setting Bookmarks and
moving to them - very handy when your trying to write multiple procedures
that work together!

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
Sent: Tuesday, November 09, 2010 2:45 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

There it is. I feel like such a newb. :)

I have used MZ Tools for it's ability to quickly add an error handler
since A97 or A2K.
When I started working with A2007, I didn't have MZ tools added in, so
I figured it was a part of MZ tools.

After adding it in, I couldn't find it in the MZ tools menu.

lol.

To get the comment/un comment block back in, from the VBA window I had
to click on the following:

View -> Toolbars -> Edit (or customize then Edit to copy them to an
existing toolbar).

Thanks again!

D

On Tue, Nov 9, 2010 at 12:26 PM, Heenan, Lambert
<Lambert.Heenan at chartisinsurance.com> wrote:
> David,
>
> That's not an MZ Tools feature, it's actually native to Access (at least
up to A2K3 which is where I live).
>
> Go into Tools/Customize, and in the resulting dialog (in Access 2003) you
will find the Comment Block and Uncomment Block command in the "Edit"
category.
>
> 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 3:14 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
>
> Lambert, (or anyone else that might know)
>
> I could swear that MZ Tools use to have an option to comment out a block
of code, much like SQL Server Management Studio does.
> Using MZ Tools with A2K7, I don't see that option any more.
>
> Do you know of a way?
>
>
>
> On Tue, Nov 9, 2010 at 11:30 AM, Heenan, Lambert
<Lambert.Heenan at chartisinsurance.com> wrote:
>> My pleasure.
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David
>> McAfee
>> Sent: Tuesday, November 09, 2010 2:21 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
>>
>> 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
>> --
>> 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





More information about the AccessD mailing list