queryDef in access 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ChasW - 08 Apr 2006 16:38 GMT

I just tried the 2nd example at this url and it starts out as:
Dim Q As QueryDef

http://support.microsoft.com/default.aspx?scid=kb;en-us;135546

..but i get user-defined type not defined. is this type present in
access 2000?

FYI, I am patched to sp-3 and the latest Jet.

Chas

Reply to this Message

MGFoster - 08 Apr 2006 18:52 GMT

> I just tried the 2nd example at this url and it starts out as:
> Dim Q As QueryDef
[quoted text clipped - 5 lines]
>
> FYI, I am patched to sp-3 and the latest Jet.

In a VBA module, on the menu bar, select Tools > References. In the
list box check the Microsoft DAO 3.6 Object Library. Then click OK.

In Access 2000 the new data access class is ADO.

Signature

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Reply to this Message