Strange VBA Editor Problems

[ChrisR]

I am having very strange problems with my VBA Editor in Access 2000.

When I am in the editor and I start to type a command I expect it to provide
the dropdown to give me selections. For example if I type DoCmd. I expect
after I type the period that there will be a drop down of options for this
command. The drop down shows up but only for a flash and then goes away,
and even if I try to scroll down through the dropdown it still disappears.
Also, when I am typing the editor keeps backspacing? For example if I try
to type msgbox ("How are you doing today?") after I type How and hit the
space bar, it automatically backspaces and tries to put it has Howare.

This seems to be something within specific mdb files. I have a few older
databases that if I open the editor everything acts normally and I get the
dropdown that stays there, and it doesn't try to backspace on me all the
time. As a matter of fact, if I open two instances of Access2000 and open
two databases (one that I know has the editor problem and one that doesn't)
I can have 2 editors open at once, one for each instance and they perform
differently at the same time. One having the strange problems and the other
behaving completely normally.

When I look at both at the same time and review the setup under
Tools...Options they are EXACTLY THE SAME. Every checkbox, every font,
everything. This is driving me nuts. I am literally opening old DB files
to write my code and then cutting/pasting to the newer file so I don't have
to deal with the editor in the new db. I have also tested someone else on
our company network opening my "bad" database and they get the same problem
on their PC, so it is not local, it is somehow tied into the mdb itself?!

Any help would be GREATLY appreciated and would go a long way towards my
mental health.

c-

 

[Dirk Goldgar]

I am having very strange problems with my VBA Editor in Access 2000.

When I am in the editor and I start to type a command I expect it to
provide the dropdown to give me selections. For example if I type
DoCmd. I expect after I type the period that there will be a drop
down of options for this command. The drop down shows up but only
for a flash and then goes away, and even if I try to scroll down
through the dropdown it still disappears. Also, when I am typing the
editor keeps backspacing? For example if I try to type msgbox ("How
are you doing today?") after I type How and hit the space bar, it
automatically backspaces and tries to put it has Howare.

This seems to be something within specific mdb files. I have a few
older databases that if I open the editor everything acts normally
and I get the dropdown that stays there, and it doesn't try to
backspace on me all the time. As a matter of fact, if I open two
instances of Access2000 and open two databases (one that I know has
the editor problem and one that doesn't) I can have 2 editors open at
once, one for each instance and they perform differently at the same
time. One having the strange problems and the other behaving
completely normally.

When I look at both at the same time and review the setup under
Tools...Options they are EXACTLY THE SAME. Every checkbox, every
font, everything. This is driving me nuts. I am literally opening
old DB files to write my code and then cutting/pasting to the newer
file so I don't have to deal with the editor in the new db. I have
also tested someone else on our company network opening my "bad"
database and they get the same problem on their PC, so it is not
local, it is somehow tied into the mdb itself?!

Any help would be GREATLY appreciated and would go a long way towards
my mental health.

This happens when you have an open form with its Timer event activated.
When the Timer event fires, the form momentarily steals the focus from
the code window, and that causes the editor to conclude that your typing
was complete.

 

[ChrisR]

That makes sense. I have a hidden form open that has a timer for checking
to see if the person logged in has been idle for >15 min and if so it shuts
down the database and logs them out. Is there any way around this or will I
just need to close the form at times that I want to do work on the database?

 

[Dirk Goldgar]

That makes sense. I have a hidden form open that has a timer for
checking to see if the person logged in has been idle for >15 min and
if so it shuts down the database and logs them out. Is there any way
around this or will I just need to close the form at times that I
want to do work on the database?

I don't know of any way around it. If you want to edit code, you must
close that form.

 

[George Nicholson]

Close the form (or maybe add code so it doesn't even open in the first place
if your UserID is encountered...)

 

[ChrisR]

Thanks for thoughts. I have problems grabbing user login using DLL because
it seems to screw up on a few users machines due to other activex controls
that are used. Anyway, the idea of closing the form made me think to put a
transparent button on the switchboard so I can just click that when I open
so that the form is closed locally for me.

Thanks again.

c-

 

[Tim Ferguson]

think to put a
transparent button on the switchboard so I can just click that when I
open so that the form is closed locally for me.

I find that using a Label_Click event is an easier way to plant "trap
door" code...


All the best


Tim F