User-defined type is not defined 1

[Keph]

Whenever I try to define something as QueryDef (i.e. Dim MyQuery As QueryDef), it gives an error message saying "User-defined type is not defined". I'm only at a beginner's level with VB, so it's confusing when examples right out of help files give errors on the second line! I've tried defining things like this in Sub's and in Function's. Any help would be greatly appreciated.

 

[MichaelRed]

I think "QueryDef" is a DAO object, but not included in the ADO object collection. Ms. A 2K (and later) sort of assume ADO, and thus NO NOT include the DAO object library by default. To use the "QueryDef" object, you would need to include the DAO 3.6 Object library and include the "DAO." predecessor as a qualifier for the database/connection/recordset ...

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[Keph]

Thanks a lot, it worked!