Compile Error - User Defined Type not defined

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ChuckW - 12 Nov 2007 16:28 GMT

Hi,

I am getting a compile error - user defined type not defined. The VB code
lists
Private Sub cmdReport Click()
Dim qdf as DAO.QueryDef

The Dim qdf as DAO.QueryDef line is highlighted. The code is part of a form
where the user selects some items and then click a button and then runs a
report. It worked about a year ago but I have not run it in a while.

Thanks,

Chuck

Signature

Chuck W

Reply to this Message

Douglas J. Steele - 12 Nov 2007 16:46 GMT

Go into the VB Editor and select Tools | References from the menu bar. If
the reference for Microsoft DAO 3.6 Object Library isn't one of the checked
ones at the top of the list, scroll through the list until you find it and
select it.

If the reference is there, but any of the other checked ones have MISSING:
in front of them, see
http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hi,
>
[quoted text clipped - 11 lines]
>
> Chuck

Reply to this Message