"Richard Cleaveland" <Ne************@rgcle.com> wrote in
news:9I******************************@comcast.com:
Well, Office 2003 should arrive today - maybe I'll have better
luck with it.
I doubt it. It's just an upgrade to A2K, which introduced the
independent VBE window, and introduced these kinds of problems with
code execution seeming to be out of synch with what you're seeing in
the application window. I've found this annoying from the first time
I ever used A2K.
On another note, the fact that it works in A97 and doesn't in A2K
does not mean everything was OK in A97. You could have compiled code
corruption in your A97 MDB that is masking an underlying compile
error. That was the basis for suggesting a decompile, though I think
you should do it in the A97 version. While it's extremely unlikely
for compiled code corruption to survive the conversion from A97 to
A2K, the hidden code corruption in A97 could make you think that the
problem was with A2K, when, in fact, it is A2K that is doing it
right and revealing a problem that was hidden in A97.
As to compiling, yes, there's automatic compilation, but I turn it
off. In the Access 97 options (and the A2K+ VBE options) I would
always turn off COMPILE ON DEMAND, which reduces the number of times
code compiles without you're requesting the compile explicitly. I
always keep the COMPILE button on my toolbar in code view, and
compile after nearly every code edit. This flushes out any problems
with my new code as soon as I've made them, rather than waiting for
an automatic compile to reveal them.
Last of all, read this article:
http://trigeminal.com/usenet/usenet004.asp?1033
Take note that the first major heading is "VBA and the 11 Stages of
Compilation." That gets your attention, eh? :)
--
David W. Fenton
http://www.dfenton.com/
usenet at dfenton dot com
http://www.dfenton.com/DFA/