Help..Complier error

[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

 

[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.

 

[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




.

 

[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.