VBA Editor Issue

[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

 

[Ken Snell]

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.

 

[Marshall Barton]

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.

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.

 

[James]

Thanks both of you are correct it was a timer event and
also I re installed and everything is ok now...

Many Thanks

James