"Dim qdftemp as QueryDef" gives me rrror Message...

[Koorosh]

Hi

I wrote a function in and in it, the statement "Dim qdftemp as QueryDef"
gives me a compiler error of "Compiler error: user-defined type not defined".

What gives? I have used this statement before in other databases and it has
worked.

 

[RoyVidar]

Hi

I wrote a function in and in it, the statement "Dim qdftemp as QueryDef"
gives me a compiler error of "Compiler error: user-defined type not defined".

What gives? I have used this statement before in other databases and it has
worked.

Ensure you have a reference to DAO. In VBE - Tools | References.
Microsoft DAO 3.6 Object Library