Art - FMS's Total Analyzer might be a better choice for what you were asking. Before you buy FMS Code Tools, try out MZTools for VBA. It's a fraction of the price and does almost everything that Code Tools does. I've been using MZTools for years and have set up custom templates for error traps, DAO recordsets, ADO recordsets, etc. I add error traps with one hot key.
Other tools you might find useful is ZTools at www.skrol39.com and SmartIndent at http://www.oaltd.co.uk/indenter/indentpage.asp While it says it works for 2000 - 2003 it also works for 2007, 2010 and probably 2013-2016, the VBA editor hasn't chnged since 2000.
-Bill
---In MS_Access_Professionals@yahoogroups.com, <dbalorenzini@yahoo.com> wrote :
With Warm Regards,
---In MS_Access_Professionals@yahoogroups.com, <dbalorenzini@yahoo.com> wrote :
I downloaded the Total Visual Code Tools trial from FMS to test it out. Thank for pointing me in the right direction.
With Warm Regards,
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (605)964-1070
"Valar Dohaeris"
On Monday, May 7, 2018 02:29:46 PM CDT, wrmosca@comcast.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Well, I guess finding and fmsinc are sort of alike. :0)
-Bill
---In MS_Access_Professionals@yahoogroups.com, <duanehookom@hotmail.com> wrote :
Stupid auto correct! www.finding .com should be www.fmsinc.com Good thing Duane posted the same thing.
---In MS_Access_Professionals@yahoogroups.com, <duanehookom@hotmail.com> wrote :
Thanks Bill,
I was wondering if there was a tool out there that I wasn't aware of.
Duane
From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of wrmosca@comcast.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Monday, May 7, 2018 12:29 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Utility for hecking for used procedures
Sent: Monday, May 7, 2018 12:29 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Utility for hecking for used procedures
Stupid auto correct! www.finding .com should be www.fmsinc.com Good thing Duane posted the same thing.
www.fmsinc.com Microsoft Access products, addins, developer tools, consulting services for Visual Studio .NET, LightSwitch, SQL Server Azure in Vienna, Virginia Washington DC |
-Bill
---In MS_Access_Professionals@yahoogroups.com, <wrmosca@comcast.net> wrote :
---In MS_Access_Professionals@yahoogroups.com, <wrmosca@comcast.net> wrote :
www.finding.com has an analyser that goes through the entire database and gives you all the info you could ever need. But it's not free. mztools.com has a code analyzer and is reasonably priced.
But I've never found one completely accurate so be sure to just comment out"unused" routines and test thoroughly before deleting them.
Regards,
Bill Mosca
------ Original message------
From: dbalorenzini@yahoo.com [MS_Access_Professionals]
Date: Sat, May 5, 2018 2:59 PM
Cc:
Subject:[MS_AccessPros] Utility for hecking for used procedures
Is there a tool or something that I can use to run through my modules and identify subs and functions, vairables, etc that are not be using in the application?
Thank you,
Art Lorenzini
Sioux Falls, SD
__._,_.___
Posted by: wrmosca@comcast.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (10) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar