Err On Dim rst As DAO.Recordset

  • Thread starter Thread starter news.microsoft.com
  • Start date Start date
N

news.microsoft.com

whem i'm using this code i will get ERR

Dim rst As DAO.Recordset


compile Error:
User-defined type not defined
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
but i saw a lot of surces are using this kind of line od code
i don't know what is problem
 
news.microsoft.com said:
whem i'm using this code i will get ERR

Dim rst As DAO.Recordset


compile Error:
User-defined type not defined
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
but i saw a lot of surces are using this kind of line od code
i don't know what is problem
Click to expand...


This is probably in a new A2K or AXP database where ADO is
the default library. You need to select the DAO library in
VBA - Tools - References.

If you do not plan on using ADO, then unselect that library.
 
Back
Top