Coding Problem

[pjscott]

I'm using Access 2003. I'm having problems when I try to type some code.
Example, in the click event I code a button to close a form. I'll type docmd.
then the docmd text and dot will turn red. You don't get the dropdown list of
events. If I continue to type close then space the dropdown list appears. But
after I type acf everything disappears. To continue I'll have to type the
orm,. After a few seconds all the text turns red again.

This doesn't happen all the time. One minute everything is fine and the next
the problem is back. I've tried un-installing and re-installing office but
that didn't help.

Anyone have an suggestion.

Thanks,

Paul

 

[StrayBullet via AccessMonster.com]

Is the cursor jumping to a different position when it turns red? If so, it
could be a problem I had run into where a timer event on a hidden form was
firing and taking focus away from the entry I was making.

 

[pjscott]

I have one adp database that does have a timer event but it's not the
database I'm currently working on.

When the code is acting weird the cursor does jump around.

Like I said it doesn't happen all the time. I can code one button to close
and everythings find. Code another button to go to the next record and the
code starts acting up.

 

[StrayBullet via AccessMonster.com]

Unfortunately, I do not know what else it could be. If I find anything, I
will let you know. Meantime, hopefully someone else will have dealt with this
before and knows a solution.

I have one adp database that does have a timer event but it's not the
database I'm currently working on.

When the code is acting weird the cursor does jump around.

Like I said it doesn't happen all the time. I can code one button to close
and everythings find. Code another button to go to the next record and the
code starts acting up.

Is the cursor jumping to a different position when it turns red? If so, it
could be a problem I had run into where a timer event on a hidden form was

[quoted text clipped - 16 lines]

 

[missinglinq via AccessMonster.com]

"I have one adp database that does have a timer event but it's not the
database I'm currently working on."

Are you sure you haven't "borrowed" code from the adp database (as we all do
from time to time) and inadvertently included the timer code?

 

[pjscott]

The only timer event that I was using was in the one adp database. I used
this timer event to display the current time and day on the opening form.

This problem is happening to another tech I work with. She deals with a
totally different adp database.

I've deleted the timer event from the adp just to see if this helps.

Thanks for the replies and have a good evening,

Paul

 

[strive4peace]

Hi Paul,

if the AutoComplete feature doesn't come on while you are coding, press
CTRL-SPACEBAR (I saw this more in Access 2000 than in 2003 -- what
version are you using?)

there are a couple things that seem to disable AutoComplete ...

also, make sure you do not have a space after the dot...



Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*