User Defined Type Not Defined

[BanditWk]

I have this front-end database located on a network with links to back-end tables and have used Recordset coding such as:

Dim Dbs as Database
Dim Rst as Recordset

Just recently, I've been receiving the error "User Defined Type Not Defined".

For my Autofill, it recognizes "Recordset" but doesn't recognize "Database" - how can this be? If you're going to write me directly, please write me at the CCCAmerica address, thanks in advance.
Roy McCafferty
aka BanditWk

Las Vegas, NV
roy@cccamerica.org
RLMBandit@aol.com (private)

"No need to send gifts, just send a smile."

 

[SgtJarrow]

I would take a guess and say you are using Access 2000 or XP. If that is the case, try:

Dim dbs As DAO.Database
Dim rst As DAO.Recordset

Also make sure you have a reference to DAO Objects 3.51 in your references If we knew what it was we were doing, it would not be called research, would it? - Albert Einstein

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com

 

[Eupher]

cnq, the 2nd part of Robert's message is critical. You must have DAO Objects 3.51 in your database references to set a variable of type Database. In a VB code window in your database, go to Tools->References, then select DAO Objects 3.51, then re-compile your code. Let us know if that does not fix your problem.

Ken S.