compile error please help

[username]

hi,

i am very new to databases n access. i have been followin this tutorial http://www.databasedev.co.uk/splash-screen.html....

everything is fine , apart frm a compile error. "User-defined type not defined"
somethin wrong in this line

db As DAO.Database

Visual basic 6.3
Access 2002


... i bet its gona be a p1$$ easy one again.

 

[MicroE]

You need to add the object library to your references.

Open any module (code). From the VBA editor’s menubar select Tools > References. Scroll down to you find the Microsoft DAO 3.x object library. Check the checkbox, and then select OK. Select Debug > Compile from the menubar to recompile the code.

 

[username]

You need to add the object library to your references.

Open any module (code). From the VBA editor’s menubar select Tools > References. Scroll down to you find the Microsoft DAO 3.x object library. Check the checkbox, and then select OK. Select Debug > Compile from the menubar to recompile the code.

hey thanks... references is disable for some reason ... as n like u cant click on it

 

[KeithG]

Thats weird maybe you are missing the dll. Try to Dim it as just a generic object instead of a DAO.Recordset.

dim DB as Object

 

[username]

thank you both of you.... i Run>Reset it... reference wrked thanks