"RC" <rc*********@yahoo.com> wrote in message
news:3c**************************@posting.google.c om...
It would be nice to have an editor or "source safe" that tracks
changes and shows relationships between things like "If" and "End If".
Source code control, and a editor that helps you work your code (if..then
blocks etc) are generally two complete separate issues.
You don't mention what version of ms-access you are using.
However, ms-access uses the same coding IDE as VB6 (arguable one of the most
widely used IDE's on the planet). So, while the code editor is not
great...it is not too bad. I sure you know the basic navigation keys (things
like placing cursor on a function or sub and whacking f2 will "leap" you to
that sub. You can continue this hopping from sub to sub. And, to traverse
backwards..you go ctrl-shift-f2).
So, assuming you spent the time to learn the IDE, and are not missing a lot
of its great features, then the next thing I would get is the best free
tools add-in for the IDE. You can find it here:
www.mztools.com
The above adds a bunch of new things (like whacking a button and getting a
list of subs/functions that USES the current routine you are in. this is
invaluable for when you have to look at/edit someone else's application).
There is all kinds of goodies in the mztools (source line counts, and number
of code aids like error handling creating etc). Really a must have add in,
and it is free!
As for source code control, you can use Visual Source safe.
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com http://www.attcanada.net/~kallal.msn 
