PC Review


Reply
Thread Tools Rate Thread

Compile Error - User Defined Type not defined

 
 
=?Utf-8?B?Q2h1Y2tX?=
Guest
Posts: n/a
 
      12th Nov 2007
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
 
Reply With Quote
 
 
 
 
Douglas J. Steele
Guest
Posts: n/a
 
      12th Nov 2007
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



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help --> Compile Error - User defined type not defined FatMan Microsoft Access VBA Modules 2 5th Feb 2009 06:25 PM
Compile error: User-defined type not defined Stapes Microsoft Access 4 7th Mar 2007 08:14 PM
Compile error: User-defined type not defined =?Utf-8?B?UklQ?= Microsoft Access VBA Modules 2 9th May 2005 06:05 AM
Compile Error User defined type not defined NewTo2002 Microsoft Access VBA Modules 2 2nd May 2005 11:46 AM
Compile error - User defined type not defined ChuckW Microsoft Access Form Coding 1 26th Feb 2005 10:17 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:12 PM.