Changing from Access VBA 97 to 2002

[rep663]

For years now, I've been writing code for a company using Access 97. I've just moved to one using Access 2002. Is there a web resource where I can find the language changes?

I understand that eventually I'll have to learn ADO stuff, but don't need it for applications here. But I'm a bit lost. For example, after I type "Dim As", I don't even see "Database" as an option on the dropdown. If I type "Dim As DAO." I don't get any dropdown at all. So I've been settling for Object, but I know there's got to be a more efficient choice.

 

[PHV]

If you want Intellisense for DAO objects then you have to reference the Microsoft DAO #.# Object Library.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[rep663]

Thanks, that did it. Actually, it wasn't so much needing to use Intellisense as wanting the code to compile. That was just an example of my confusion.

Thanks again.