I'm working in Access 2K quite a bit lately (with only my second
project that is 100% A2K), and I've run into a number of odd
problems that seem to be associated with running code.
The most recent problem was a new form that I was working on and I
had placed a navigation combo box on the form, and I was about to
write a BeforeUpdate event that would use Trevor Best's tCount()
(replacement for the builtin dCount()) to see if there were any
records to navigate to or not and cancel the update if there
weren't.
So far so good.
So, I type If tCount( and see from the lack of Intellisense that I
haven't yet imported tCount() into this app.
So, I copy the code from my reference copy and go to paste it into
my module for other people's code. I hit compile, and get an error
because I had imported a form from a non-related app to use as a
model for some of the things in this new app. So, I reset code and
then delete the model form. I get an error message that says
"cannot halt code execution" or some such. But the form was
deleted, so I was happy. I then go back to the form where I'd typed
tCount( and attempt to get to its code to continue, but I can't --
all efforts to view its code fail (including using the Project
Explorer, where there is no form module listed). So, I change the
HasModule to NO, save and reopen the form and I can work again.
Now, I think the issue may have been caused by deleting a form that
had caused a break in the compile process while I still had
*another* uncleared compilation break pending, but why it corrupted
an unrelated form, I don't know.
The other problem I'm having is that after certain periods of time
and in situations that I can't see any pattern, the keyboard just
stops working in Access 2K. The mouse still works in A2K and I
can't see that there's any code executing, and the keyboard
continues to work in other applications. I can only get it to work
again by shutting down A2K and restarting.
The version of Access is 9.0.3821 SR-1, which is what I've been
using all over the place for a long time, and on this PC for quite
some time (and it's Jet SP6, as well). Though I re-installed Win2K
at the end of June, this problem has only emerged in the last month
or so.
Now, I do know that my keyboard is a bit flakey (anyone know where
you can get a standard keyboard without any extra keys on it that
is durable and doesn't cost a fortune?), but I've had this keyboard
for about 18 months and so I can't really blame it on this.
Perhaps the problem emerged after I installed the RPC patches MS
put out after the Blaster worm emerged. That's the only major
change to my system since I got back from California in August.
Any comments?
I just find it really confusing the way the VBE tells me code is
still executing when I've already reset it. I really don't
understand what's going on and with A2K I feel like I can not
control Access nearly as well as I can with A97.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc