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