I wish to use the sample from Smith & Sussman's "Beginning Access (97 or

2K) VBA Programming," but the statement "Dim db as Database" results in the

message "User-Defined data type not defined." from the compiler when I add

it to a database of mine, although it works fine in their IceCream databases.



I have figured out from the help that either they have the "Type db ....

end type" in IceCream somewhere where I can't find it or they have included

an object or type library that I need to identify and register.



Does anyone know?



Paul Streeter

You are missing a reference to the Microsoft DOA library.  Open any

module and select Tools > References and select the appropriate library.



-----Original Message-----

From: Paul G Streeter [mailto:PStreeter@C...] 

Sent: Friday, January 25, 2002 10:34 PM

To: Access

Subject: [access] QueryDef - Creating queries through VBA





I wish to use the sample from Smith & Sussman's "Beginning Access (97 or

2K) VBA Programming," but the statement "Dim db as Database" results in

the message "User-Defined data type not defined." from the compiler when

I add it to a database of mine, although it works fine in their IceCream

databases.



I have figured out from the help that either they have the "Type db ....

end type" in IceCream somewhere where I can't find it or they have

included an object or type library that I need to identify and register.



Does anyone know?



Paul Streeter

On Fri, 25 Jan 2002 15:01:11 -0800 "John Ruff" wrote:



> You are missing a reference to the Microsoft DOA library.  Open any

> module and select Tools > References and select the appropriate library.

> 

Perfect.  Thanks