Help..Complier error

R

Raj

I am trying to use code that I found on the web that well
let me add a new entry to a combo box. When I tried to
run the code I get a Compile error: User-defined type not
defined. This happens at the Dim db AS DAO.Datbase..
I am a neophyte to coding and hope that someone can help
me..
Thanks
 
C

Cheryl Fischer

While in the VB editor, click Tools on the menu and then select References.
Do you have a reference set to Microsoft x.xx DAO Object Library? If not,
you will need to set it. If you are using Access 2000 or newer the x.xx
should be 3.61; otherwise, for Access 97, it should be 3.51.
 
R

Raj

Cheryl,
Thank you..
-----Original Message-----
While in the VB editor, click Tools on the menu and then select References.
Do you have a reference set to Microsoft x.xx DAO Object Library? If not,
you will need to set it. If you are using Access 2000 or newer the x.xx
should be 3.61; otherwise, for Access 97, it should be 3.51.



--
Cheryl Fischer
Law/Sys Associates
Houston, TX




.
 
J

John Vinson

User-defined type not
defined. This happens at the Dim db AS DAO.Datbase..

Access 200x defaults to using the ADO object model. Open any module in
the VBA editor and select Tools... References; scroll down until you
find Microsoft DAO x.xx Object Library (the highest version if there
are more than one) and check it.
 

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