Intellisense Problem

[Wayne Wengert]

I am using Access 2003 to try to follow a tutorial
(http://www.aspfree.com/c/a/Microsoft-Access/Connecting-to-Microsoft-Access-with-ADO/4/)
but after adding the reference to ADO 2.8 I still don't get any
Intellisense? Is there something else I need to enable?

 

[Granny Spitz via AccessMonster.com]

Is there something else I need to enable?

Open the VB Editor and go to Tools | Options... | Editor. Make sure the Auto
List Members check box is checked.

 

[Wayne Wengert]

Thanks for the suggesgtion but that is already checked

 

[Guest]

If your problem is relative to the scroll button not working in the VBA
editor window you need to get/install either FreeWheel or VBScroll. Either
work very well. Do a search on google and you'll get them easily.

Daniel

 

[Norman Yuan]

There may be invalid code causing this. In VBA Editor, click menu
"Debug->Compile..." to have VBA Editor catch the bad code.

 

[Wayne Wengert]

Thnks for that info. I did that and it is complaining about the following:

strAdd = strAdd + "ADO version used is: " & conn.Version

saying "member not found" - it points to "Version". That is the exact code
from the tutorial?