User type not defined Newbie vba

  • Thread starter Thread starter Stefan
  • Start date Start date
S

Stefan

I am trying to define a variable as a table

Dim Table As New Table

I get this message when I try to compile

User defined type not defined.

I have tried using the references box to select from the
object libary with no luck.

Any Help?? Thanks in advance
 
Originally posted by Stefan
I am trying to define a variable as a table

Dim Table As New Table

I get this message when I try to compile

User defined type not defined.

I have tried using the references box to select from the
Click to expand...
object libary with no luck.

Any Help?? Thanks in advance
Click to expand...



Try adding the msadox.dll to your references....
 
I am trying to define a variable as a table

Dim Table As New Table

I get this message when I try to compile

User defined type not defined.
Click to expand...

Well... that's because there is no such Type as Table. TableDef yes,
but not Table.

Could you explain what you're trying to accomplish?
 
-----Original Message-----


Well... that's because there is no such Type as Table. TableDef yes,
but not Table.

Could you explain what you're trying to accomplish?


.
I actually bought Sams teach yourself access 2002
Click to expand...
programming and was doing one of the lessons to create a
new table and define columns with code.
 
Back
Top