VBA Editor Issue

  • Thread starter Thread starter James
  • Start date Start date
J

James

Hello,
Not sure if I am posting in the right newsgroup but
my VBA Editor is apparently broken. Some one who assisted
me with a database looked at it and told me this and teh
problem they descrbed was the following:

Whenever I tried to type a command, it would prevent me
from doing some things even though auto syntax was off.

Is there a way to fix this?

Many Thanks

James
 
Prevent you in what way? Does it "interrupt" and "prematurely terminate"
your typing?

If so, likely what you're dealing with is that you have a timer event
occurring within your database. Each time the timer event occurs, the VB
editor will stop and run the code associated with the event; thus, it'll
have the behavior noted in my initial question.

Turn off the timer event and then things should be ok.
 
James said:
Not sure if I am posting in the right newsgroup but
my VBA Editor is apparently broken. Some one who assisted
me with a database looked at it and told me this and teh
problem they descrbed was the following:

Whenever I tried to type a command, it would prevent me
from doing some things even though auto syntax was off.
Click to expand...


The most common cause of the editor misbehaving is that you
have an open form that's running a timer event. If so, then
close the form before using the editor.

The only other reason I've heard of is a messed up
installation. Usually, a repair or reinstall will resolve
this one.
 
Thanks both of you are correct it was a timer event and
also I re installed and everything is ok now...

Many Thanks

James
 
Back
Top