Error in editor

rjmac45

New member
Local time
Yesterday, 20:50
Joined
Jan 13, 2010
Messages
2
I am new and pretty raw and there is something basically wrong I know.

Each time I run my module it comes back with Compile Error: user defined Type not defined
and this is what it complains about

Dim objConn As ADODB.Connection

What am I missing?
 
What am I missing?
A reference to ActiveX. Go to the VBA window and TOOLS > REFERENCES and scroll down until you find the Microsoft ActiveX Data Objects xx.x Library

where xx.x is the latest number available.
 
A reference to ActiveX. Go to the VBA window and TOOLS > REFERENCES and scroll down until you find the Microsoft ActiveX Data Objects xx.x Library

where xx.x is the latest number available.

boblarson

Thank You
 

Users who are viewing this thread

Back
Top Bottom