Databases

Every time I use the Data Form wizard to make a program that accesses a database I get a User Defined Type not defined. error. The problem code is

Private Sub datPrimaryRS_MoveComplete(ByVal adReason As ADODB.EventReasonEnum, ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset)
'This will display the current record position for this recordset
datPrimaryRS.Caption = "Record: " & CStr(datPrimaryRS.Recordset.AbsolutePosition)
End Sub


I'm using VB6 and have got Office 2000 installed.

Help!! :(

------------------
Matthew Ralston
E-Mail: m.ralston@mediavault.co.uk
ICQ:31422892 (http://195.89.158.103/icq.html)
Web Sites:The Blue Link (http://195.89.158.103) My Home Page (http://mralston.cjb.net)

[Crazy D]

Set a reference (Projects menu - references) to the Microsoft ActiveX Data Objects library (ADO).
You can easily check it...
dim aaa as ADO... now you should see ADODB in the list .. if not then you haven't set the reference...
(sorry, but the F1 key could have helped you out pretty well here...)

Cheers! (As for the F1 bit I've only installed MSDN help to run off the CD and I ain't get 'em 'andy at the moment...)

------------------
Matthew Ralston
E-Mail: m.ralston@mediavault.co.uk
ICQ:31422892 (http://195.89.158.103/icq.html)
Web Sites:The Blue Link (http://195.89.158.103) My Home Page (http://mralston.cjb.net)