Farewell, dear Intellisense (Access 2003 VBA)

[McDimwitty]

I am at work doing VBA when suddenly Intellisense stopped working.

It's a pretty simple application: recordsets, sql, some classes. Nothing else really.

It's working for declaring variables like: Dim A as (and it pops up a list of data types). However, it doesn't work for my classes or working with ADO like: rst. (and it should pop up valid stuff for recordsets).

How do I get my friend Intellisense back??? I sorely miss it.

=-= Mr McDimwitty =-=

 

[DJkarl]

Intellisense only works for objects if you have the proper references installed, I'll assume that you do because it just recently stopped working. Do you have a form open in the background with a timer running? This can seemingly kill this feature because code is constantly executing while you are typing.

 

[McDimwitty]

Intellisense only works for objects if you have the proper references installed, I'll assume that you do because it just recently stopped working. Do you have a form open in the background with a timer running? This can seemingly kill this feature because code is constantly executing while you are typing.

- I have no timers in my application.

- I intentionally type in lower case in order to see the variables change and confirm that I spelled things right. Even though the Intellisense doesn't work, the properties of my classes do change to the right case. That suggests that my classes are okay.

One thing that I noticed, though. When I am in a procedure, I click on Definition on the class name to get back to class module. It says it doesn't recognize the class. Keep in mind the earlier point of typing in lower case and it corrects the case of the properties.

 

[RuralGuy]

Have you tried a Compact and Repair and/or importing everything into a fresh mdb? Do you have Name AutoCorrect turned off? What version of Access?

 

[DJkarl]

I've also had this happen when I've had a compile error or a duplicate declaration somewhere.

 

[McDimwitty]

I've also had this happen when I've had a compile error or a duplicate declaration somewhere.

I think that was it. Thanks.

 

[McDimwitty]

Have you tried a Compact and Repair and/or importing everything into a fresh mdb? Do you have Name AutoCorrect turned off? What version of Access?

The problem is solved. However, I am curious. How do you turn on and off AutoCorrect. This is my first Access app I am doing.

 

[RuralGuy]

Tools>Options...>General Tab
Uncheck Track name Autocorrect Info on the right side.
Failures caused by Name AutoCorrect
Glad you got your problem sorted.