By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,234 Members | 1,832 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,234 IT Pros & Developers. It's quick & easy.

better VBA editor? Does anyone know of a better VBA editor for Access?

P: n/a
RC
It would be nice to have an editor or "source safe" that tracks
changes and shows relationships between things like "If" and "End If".

Anyone know of any other possibilities? I found one but I can't
afford the $300 USD price.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"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
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.