Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can i fix User-defined type not defined

Status
Not open for further replies.

hrg

Programmer
Jan 8, 2009
46
US
I keep on getting an error

"User-defined type not defined"

and it hight lights the below text in yellow

"Private Sub Text43_Change()"

and higligths the below text in blue

"Dim trs AS DAO.Recordset"

why is this? what does this mean? How can i fix it?
 
You need to see that you have the dao library listed in your references. Open the module, go to menu, tools, references. It's possible you have ADO and not DAO. Look for a 'missing' in the list of references, or look down the list for something like Microsoft DAO 3.51 object library, and check that reference.
--Jim
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top