From: RonG on
Hi,

As I move away from Access97 and towards Access2007 and beyond, I have
to replace some of my well-worn developer tools. One that I really
like a lot is Speed Ferret, an add-in that gave me enhanced "find and
replace" capabilities.

Unfortunately, it looks like there won't be a Speed Ferret for
Access2007, so I'm wondering if anyone has a worthwhile replacement
that they like?

Also, I've made use of the FMS tools, such as Access Analyzer and the
like. Are they still considered "top of the heap" when it comes to to
doing development work on Acc2007?

Any thoughts would be appreciated.

Thanks.

Ron
From: Albert D. Kallal on
The FMS tools are still great and some of the best that money can buy.

The other free must have is MZTOOLS.
http://www.mztools.com

mztooms has the ability to insert error handling, and also has nice things
like display a list of routines that "calls" the current code you are
looking at.

For years we always been able to place the cursor on a sub/function and
hitting shift f2 jumps to routine, this allows you to "surf" your code, and
ctrl+shift+f2 lets you un-cork you way back.

However, mztools allows the ability while looking at a code routine to
displays a list of all OTHER code routines that call the current routine you
are looking at (this is invaluable, especially when looking at others code).


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal(a)msn.com


From: RonG on
Hi Albert,

Thanks for that info. I'll take a look at those. I asked the folks at
FMS, and while they have very good tools, a couple of which I already
use, they say that they don't have anything that matches the
capabilities of Speed Ferret right now. Perhaps MZTools.

Ron




On Feb 28, 1:19 pm, "Albert D. Kallal" <PleaseNOOOsPAMmkal...(a)msn.com>
wrote:
> The FMS tools are still great and some of the best that money can buy.
>
> The other free must have is MZTOOLS.http://www.mztools.com
>
> mztooms has the ability to insert error handling, and also has nice things
> like display a list of routines that "calls" the current code you are
> looking at.
>
> For years we always been able to place the cursor on a sub/function and
> hitting shift f2 jumps to routine, this allows you to "surf" your code, and
> ctrl+shift+f2 lets you un-cork you way back.
>
> However, mztools allows the ability while looking at a code routine to
> displays a list of all OTHER code routines that call the current routine you
> are looking at (this is invaluable, especially when looking at others code).
>
> --
> Albert D. Kallal    (Access MVP)
> Edmonton, Alberta Canada
> pleaseNOOSpamKal...(a)msn.com

From: Sky on
On 3/1/2010 5:38 PM, RonG wrote:
> Hi Albert,
>
> Thanks for that info. I'll take a look at those. I asked the folks at
> FMS, and while they have very good tools, a couple of which I already
> use, they say that they don't have anything that matches the
> capabilities of Speed Ferret right now. Perhaps MZTools.
>
> Ron
>

For search and replace, look at:
http://www.rickworld.com/

It works fine in all versions of Access including 2007, although it has
been listed as "beta" for the latter. It's what I've used for last
several years since Speed Ferret went stagnant.

Steve