Problem with Declaring Variables

[pcdaveh]

I've been coding for a couple of years now and have never experienced this problem. I'm trying to declare a variable and the "I call it intelli-help" stops functioning not allowing me to declare a variable. Example

I'll type:

"Dim" then space to type the variable name and immediately the word Dim changes to red the cursor moves from the spaced position back the m in Dim. If I force the the declaration of a variable by typing it lets say in note pad or word pad then paste it into my access application then It will work.

Example:

Dim mytestVar as integer ' I just typed this into my browser and copied back to Access and that's fine. Now if I
try to use that variable I'll type it's name and try to put an "=" after the name and everything turns red.

mytestVar= ' this is as far as I can get.

 

[Nancy2]

Very strange -- did you check for missing references? Do your also do your functions work i.e., date()?

 

[Craig0201]

Dave,

Had this on my PC yesterday. Solved it by closing the instance of Access and reopening.

Craig

 

[pcdaveh]

I think I found the answer. Some of you may want to take note of this. I had a form with some code that was commented out in the On Timer Event. All the code was commented out. It was used to call another routine every so often but again it was all commented out. But as soon as I removed the code my problem ceased.