Compile Error - User Defined Type not defined

Compile Error - User Defined Type not defined

Post by Q2h1Y2t » Wed, 14 Nov 2007 01:28:01


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
--
Chuck W
 
 
 

Compile Error - User Defined Type not defined

Post by Douglas J. » Wed, 14 Nov 2007 01:46:00

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.yqcomputer.com/

--
Doug Steele, Microsoft Access MVP
http://www.yqcomputer.com/
(no e-mails, please!)