ADO recordsets!!!! help!!! (1 Viewer)

CHAOSinACT

Registered User.
Local time
Tomorrow, 04:21
Joined
Mar 18, 2009
Messages
235
I have been trying to implement code from the access 2007 bible.... everytime i try to implement the anything to do with ADO it won't run!

coppied code from bible exactly, going insane! is there some library includes to get ADO running or what!?!

just including this line causes runtime errors:

Dim rs As ADODB.Recordset

never mind the rest, that kills it! I can do
Dim rs As Recordset but want to work with ADO for dynamic sql updates...

Thanks,
Carl
 

EraserveAP

Registered User.
Local time
Today, 13:21
Joined
Jul 22, 2008
Messages
56
Did you set the reference for it in the Tools/References?
 

CHAOSinACT

Registered User.
Local time
Tomorrow, 04:21
Joined
Mar 18, 2009
Messages
235
what to include! learning this from manual, done some vba in the past but been ages (i'm really more of a lisp programmer).

Thanks,
Carl
 

DCrake

Remembered
Local time
Today, 17:21
Joined
Jun 8, 2005
Messages
8,632
Try

Dim Rs As New ADODB.Recordset
 

EraserveAP

Registered User.
Local time
Today, 13:21
Joined
Jul 22, 2008
Messages
56
what to include! learning this from manual, done some vba in the past but been ages (i'm really more of a lisp programmer).

Thanks,
Carl

Once you have the references window open Scroll down for Microsoft Activex Data Objects X.x Library, where X.x is the latest Number, then place a check mark. I am not sure but you may also need Microsoft ADO Ext X.x for DDL and Security.
 

CHAOSinACT

Registered User.
Local time
Tomorrow, 04:21
Joined
Mar 18, 2009
Messages
235
It was the references THANK YOU THANK YOU THANK YOU!!!!!
 

Users who are viewing this thread

Top Bottom