Recordsets results in "User-defined type not defined" 
Author Message
 Recordsets results in "User-defined type not defined"

Hi,
I'm having a problem with VB 5.0, where I want to declare a variable
as a recordset, just like I'm doing in MS Access:

Dim rs As Recordset

The compiler do NOT like it and says "User-defined type not defined."
What does it mean? The same problem occurs if I try to declare a
database, workspace...

What have I done wrong? Can it be something during the installation?

Please help
Magnus Karlsson



Sun, 21 Nov 1999 03:00:00 GMT  
 Recordsets results in "User-defined type not defined"

Quote:

> Hi,
> I'm having a problem with VB 5.0, where I want to declare a variable
> as a recordset, just like I'm doing in MS Access:

> Dim rs As Recordset

> The compiler do NOT like it and says "User-defined type not defined."
> What does it mean? The same problem occurs if I try to declare a
> database, workspace...

> What have I done wrong? Can it be something during the installation?

> Please help
> Magnus Karlsson

I don't have 5.0 yet, but this will occur in 4.0 if you don't
have the "Tools->References->DAO" checked.  In other words, the
object(s) aren't available until you ask for them.

--
Barry Scott



Sun, 21 Nov 1999 03:00:00 GMT  
 Recordsets results in "User-defined type not defined"

I had the same problem (but in VB4).Selecting "Microsoft DAO 2.5/3.0
Compatibility Library" under Tools / References fixed it.


Quote:
> Hi,
> I'm having a problem with VB 5.0, where I want to declare a variable
> as a recordset, just like I'm doing in MS Access:

> Dim rs As Recordset

> The compiler do NOT like it and says "User-defined type not defined."
> What does it mean? The same problem occurs if I try to declare a
> database, workspace...

> What have I done wrong? Can it be something during the installation?

> Please help
> Magnus Karlsson



Mon, 22 Nov 1999 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. FileSystemObject "User Defined Type Not Defined"

2. "User defined type, not defined"

3. "Database - user defined type not defined"????

4. "User-defined type not defined"

5. Recordsets results in "User-defined type not defined"

6. User Control - User-defined type not defined

7. User Defined Type Not Defined

8. Compile Error: User-defined type not defined

9. User-defined type not defined (Access 97)

10. Excel : User-defined type not define

11. Compile Error - User defined type not defined

12. User-defined type not defined (Access 2000)

 

 
Powered by phpBB® Forum Software