I am not sure why this is happening....

I am in the visual basic editor trying to update the code for a database.
As I type, the code backs up, turns red and otherwise annoys me as I am
trying to type. I have turned off the Auto Syntax Check as well as all of
the "auto" do anything features under the Tools - Options Editor Tab.

It is really annoying as it completes goofs up the code as I type. How do I
shut this off? The odd thing is that it didn't use to do that. It started,
then stopped, and has started again.....

Does anyone have any ideas??????

Thanks in advance

Don

Don, any chance you have a form with a Timer event?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Don Ireland" <(E-Mail Removed)> wrote in message
news:5592471F-DC6C-459C-BB8E-(E-Mail Removed)...
>I am not sure why this is happening....
>
> I am in the visual basic editor trying to update the code for a database.
> As I type, the code backs up, turns red and otherwise annoys me as I am
> trying to type. I have turned off the Auto Syntax Check as well as all of
> the "auto" do anything features under the Tools - Options Editor Tab.
>
> It is really annoying as it completes goofs up the code as I type. How do
> I
> shut this off? The odd thing is that it didn't use to do that. It
> started,
> then stopped, and has started again.....
>
> Does anyone have any ideas??????
>
> Thanks in advance
>
> Don

No timer event.... It also completely ignores spaces... automatically
inserts double-quotes when a syntax requires them, and a few other oddball
things.

Please keep in mind that this happens when programming in VB not when using
the actual database. Alse, the behavior is not evident when programming
Excel VB...only Access.



"Allen Browne" wrote:

> Don, any chance you have a form with a Timer event?
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Don Ireland" <(E-Mail Removed)> wrote in message
> news:5592471F-DC6C-459C-BB8E-(E-Mail Removed)...
> >I am not sure why this is happening....
> >
> > I am in the visual basic editor trying to update the code for a database.
> > As I type, the code backs up, turns red and otherwise annoys me as I am
> > trying to type. I have turned off the Auto Syntax Check as well as all of
> > the "auto" do anything features under the Tools - Options Editor Tab.
> >
> > It is really annoying as it completes goofs up the code as I type. How do
> > I
> > shut this off? The odd thing is that it didn't use to do that. It
> > started,
> > then stopped, and has started again.....
> >
> > Does anyone have any ideas??????
> >
> > Thanks in advance
> >
> > Don
>
>
>

Don't know what to suggest, Don, so if anyone else has an idea, please jump
in.

Presumably you have disabled any other Add-ins in the VBA window?
Never had the VBA IDE sticking quotes in for me.
Had a worn-out keyboard where Spacebar did not work reliably. :-)
AutoKeys marco should not affect VBA window.
Keyloggers/viruses/generic keyboard enhancers could be a factor.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Don Ireland" <(E-Mail Removed)> wrote in message
news7580418-6A20-4D5F-85C3-(E-Mail Removed)...
> No timer event.... It also completely ignores spaces... automatically
> inserts double-quotes when a syntax requires them, and a few other oddball
> things.
>
> Please keep in mind that this happens when programming in VB not when
> using
> the actual database. Alse, the behavior is not evident when programming
> Excel VB...only Access.
>
> "Allen Browne" wrote:
>
>> Don, any chance you have a form with a Timer event?
>>
>> "Don Ireland" <(E-Mail Removed)> wrote in message
>> news:5592471F-DC6C-459C-BB8E-(E-Mail Removed)...
>> >I am not sure why this is happening....
>> >
>> > I am in the visual basic editor trying to update the code for a
>> > database.
>> > As I type, the code backs up, turns red and otherwise annoys me as I am
>> > trying to type. I have turned off the Auto Syntax Check as well as all
>> > of
>> > the "auto" do anything features under the Tools - Options Editor Tab.
>> >
>> > It is really annoying as it completes goofs up the code as I type. How
>> > do
>> > I
>> > shut this off? The odd thing is that it didn't use to do that. It
>> > started,
>> > then stopped, and has started again.....

To reiterate what Allen Browne said.

The only time I've seen this behavior is when I have a form open with a timer
event running. It doesn't have to be the form I am working on, any form (even a
hidden one) with a timer grabs the focus when the timer event gets triggered.

Don Ireland wrote:
>
> No timer event.... It also completely ignores spaces... automatically
> inserts double-quotes when a syntax requires them, and a few other oddball
> things.
>
> Please keep in mind that this happens when programming in VB not when using
> the actual database. Alse, the behavior is not evident when programming
> Excel VB...only Access.
>
> "Allen Browne" wrote:
>
> > Don, any chance you have a form with a Timer event?
> >
> > --
> > Allen Browne - Microsoft MVP. Perth, Western Australia.
> > Tips for Access users - http://allenbrowne.com/tips.html
> > Reply to group, rather than allenbrowne at mvps dot org.
> >
> > "Don Ireland" <(E-Mail Removed)> wrote in message
> > news:5592471F-DC6C-459C-BB8E-(E-Mail Removed)...
> > >I am not sure why this is happening....
> > >
> > > I am in the visual basic editor trying to update the code for a database.
> > > As I type, the code backs up, turns red and otherwise annoys me as I am
> > > trying to type. I have turned off the Auto Syntax Check as well as all of
> > > the "auto" do anything features under the Tools - Options Editor Tab.
> > >
> > > It is really annoying as it completes goofs up the code as I type. How do
> > > I
> > > shut this off? The odd thing is that it didn't use to do that. It
> > > started,
> > > then stopped, and has started again.....
> > >
> > > Does anyone have any ideas??????
> > >
> > > Thanks in advance
> > >
> > > Don
> >
> >
> >

I third that "reiterate" or would it be a second of the "reiterate"....
These are the exact symptoms of any other form currently open and running
code in the timer event.

--
Duane Hookom
MS Access MVP
--

"John Spencer" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> To reiterate what Allen Browne said.
>
> The only time I've seen this behavior is when I have a form open with a
> timer
> event running. It doesn't have to be the form I am working on, any form
> (even a
> hidden one) with a timer grabs the focus when the timer event gets
> triggered.
>
> Don Ireland wrote:
>>
>> No timer event.... It also completely ignores spaces... automatically
>> inserts double-quotes when a syntax requires them, and a few other
>> oddball
>> things.
>>
>> Please keep in mind that this happens when programming in VB not when
>> using
>> the actual database. Alse, the behavior is not evident when programming
>> Excel VB...only Access.
>>
>> "Allen Browne" wrote:
>>
>> > Don, any chance you have a form with a Timer event?
>> >
>> > --
>> > Allen Browne - Microsoft MVP. Perth, Western Australia.
>> > Tips for Access users - http://allenbrowne.com/tips.html
>> > Reply to group, rather than allenbrowne at mvps dot org.
>> >
>> > "Don Ireland" <(E-Mail Removed)> wrote in message
>> > news:5592471F-DC6C-459C-BB8E-(E-Mail Removed)...
>> > >I am not sure why this is happening....
>> > >
>> > > I am in the visual basic editor trying to update the code for a
>> > > database.
>> > > As I type, the code backs up, turns red and otherwise annoys me as I
>> > > am
>> > > trying to type. I have turned off the Auto Syntax Check as well as
>> > > all of
>> > > the "auto" do anything features under the Tools - Options Editor Tab.
>> > >
>> > > It is really annoying as it completes goofs up the code as I type.
>> > > How do
>> > > I
>> > > shut this off? The odd thing is that it didn't use to do that. It
>> > > started,
>> > > then stopped, and has started again.....
>> > >
>> > > Does anyone have any ideas??????
>> > >
>> > > Thanks in advance
>> > >
>> > > Don
>> >
>> >
>> >

I FOUND THE PROBLEM!!!!!!!!!!!!!!!!!

It was exactly what everyone said and then reiterated multiple times. There
was a subroutine that was started for the timer event. All of the code was
removed except for the Sub <form name> timer and End Sub statements. The
timer value was set to 1000 so it was checking the timer every second. I
think at one point, we tried putting a clock in the database but that caused
problems for some and annoyed others, so it was removed - partially.

Thanks for all the help! It only took about a month to find!

"Duane Hookom" wrote:

> I third that "reiterate" or would it be a second of the "reiterate"....
> These are the exact symptoms of any other form currently open and running
> code in the timer event.
>
> --
> Duane Hookom
> MS Access MVP
> --
>
> "John Spencer" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > To reiterate what Allen Browne said.
> >
> > The only time I've seen this behavior is when I have a form open with a
> > timer
> > event running. It doesn't have to be the form I am working on, any form
> > (even a
> > hidden one) with a timer grabs the focus when the timer event gets
> > triggered.
> >
> > Don Ireland wrote:
> >>
> >> No timer event.... It also completely ignores spaces... automatically
> >> inserts double-quotes when a syntax requires them, and a few other
> >> oddball
> >> things.
> >>
> >> Please keep in mind that this happens when programming in VB not when
> >> using
> >> the actual database. Alse, the behavior is not evident when programming
> >> Excel VB...only Access.
> >>
> >> "Allen Browne" wrote:
> >>
> >> > Don, any chance you have a form with a Timer event?
> >> >
> >> > --
> >> > Allen Browne - Microsoft MVP. Perth, Western Australia.
> >> > Tips for Access users - http://allenbrowne.com/tips.html
> >> > Reply to group, rather than allenbrowne at mvps dot org.
> >> >
> >> > "Don Ireland" <(E-Mail Removed)> wrote in message
> >> > news:5592471F-DC6C-459C-BB8E-(E-Mail Removed)...
> >> > >I am not sure why this is happening....
> >> > >
> >> > > I am in the visual basic editor trying to update the code for a
> >> > > database.
> >> > > As I type, the code backs up, turns red and otherwise annoys me as I
> >> > > am
> >> > > trying to type. I have turned off the Auto Syntax Check as well as
> >> > > all of
> >> > > the "auto" do anything features under the Tools - Options Editor Tab.
> >> > >
> >> > > It is really annoying as it completes goofs up the code as I type.
> >> > > How do
> >> > > I
> >> > > shut this off? The odd thing is that it didn't use to do that. It
> >> > > started,
> >> > > then stopped, and has started again.....
> >> > >
> >> > > Does anyone have any ideas??????
> >> > >
> >> > > Thanks in advance
> >> > >
> >> > > Don
> >> >
> >> >
> >> >
>
>
>