Compile Error - User Defined Type not defined

C

ChuckW

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
 
D

Douglas J. Steele

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top