VB Editor Auto prompt turning off problem

  • Thread starter Thread starter duncanjx
  • Start date Start date
D

duncanjx

Hi there
I am starting to write VB for my databases. Good so far but in some
databases for example when I am in the VB Editor and write "DoCmd." I
get a list of options but then it disappears. It seems to last about 2
or 3 seconds.

Have I accidently turned something off? It makes it very hard trying
to work out the rest of the prompts.

Can someone help??????????

Duncan
 
Hi there
I am starting to write VB for my databases. Good so far but in some
databases for example when I am in the VB Editor and write "DoCmd." I
get a list of options but then it disappears. It seems to last about 2
or 3 seconds.

Have I accidently turned something off? It makes it very hard trying
to work out the rest of the prompts.

Can someone help??????????

Duncan
Click to expand...

The usual "culprit" is that you have a form open (while you are
editing the VBA) that has a timer event running.
If the timer event is in a different form, close that form. then edit
your code.
If the timer event is on the form you are editing, temporarily reset
the Timer interval to 0. Edit your code then change the Timer interval
back to whatever it was.
 
I agree with Fred.  However, if the timer is in the form you
are editing, I strongly recommend that you go one step
further and instead of setting TimerInterval to 0, that you
switch the form back to design view before making *any* code
changes to the form's module.
Click to expand...

Thank you for the advice. I had a routine DetectIdleTime loaded as a
hidden form from my autoexec macro.
I have a mock up of a work database. I stopped it loading and that
fixed the time out of the VBA options.
Cheers
 
Back
Top