VBA Trouble

  • Thread starter Thread starter rom
  • Start date Start date
R

rom

Hi.
The spacebar stops working all of a sudden. Specifically
when I start typing from the beginning of the line.
Always happens when I start typing for example the
following command:

Dim rst As Object

The spacebar does not actually produce a space. The cursor
just stays in the same spot. It comes out like this:

dimrstasobject

If I go back to it, I can then add spaces.
The only temporary way to fix this, is to close the file
and reopen it. But eventually, the error will come back
minutes later.

I have tried copying the program to another computer, and
I get the same error, so I figured Microsoft Access is not
corrupted. I have tried making a new database and
importing everything to it, and it still happens. So I
figured its not the database that corrupted. I have also
tried reinstalling Access 2000. Nothing.
So what could it be?
 
If I go back to it, I can then add spaces.
The only temporary way to fix this, is to close the file
and reopen it. But eventually, the error will come back
minutes later.
Click to expand...

IfyouhaveaformactivewithaTimerControlonit,closetheform.

HTH


Tim F
 
That's pretty funny. Yeah, the bug is very annoying.
The database uses extensive VBA and I would not like to
loose it.
I do have a form with a timer control, but it is not open
while I experience these problems. I'll check again
though. So you're saying that this error is due to
something running in the background and not a database
corruption. Sounds pretty good. I'll look into it. Any
other suggestions would be appreciated.

Thankyou very much
 
Wow! Thankyou for your help Tim F. You were right. I
accidently had activated a form's timer event and that
form was always open while I was in VBA. There was nothing
in the Timer Event Subroutine but the timer was set to 10.
I haven't tested it yet after removing the timer event,
but I'm pretty sure that was the problem. I was very
worried before. Thankyou very much
 
There was nothing
in the Timer Event Subroutine but the timer was set to 10.
I haven't tested it yet after removing the timer event,
but I'm pretty sure that was the problem. I was very
worried before. Thankyou very much
Click to expand...

My pleasure, but I must confess that this solution was posted here some
time ago, and it stuck with me because it's such an odd condition/ cure.

All the best


Tim F
 
Back
Top