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/Ac...nceErrors.html
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"ChuckW" <(E-Mail Removed)> wrote in message
news:FD0B6405-7894-4948-B37E-(E-Mail Removed)...
> 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