Microsoft Office Forums - View Single Post - SQL ADODB.RecordSet Error 91

Thread: SQL ADODB.RecordSet Error 91

View Single Post

Old

04-30-2012, 04:36 AM

Colin Legg Colin Legg is offline

Colin Legg is offline

Colin Legg uses Windows 7 32bit

Windows 7 32bit Colin Legg uses Office 2010 32bit

Colin Legg uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Default

You have to create an instance (an object) of the recordset before you can do things with it such as call its Open method.

Code:

Dim rsCount As ADODB.Recordset

Set rsCount = CreateObject("ADODB.RecordSet")

__________________
Colin

RAD Excel Blog

Reply With Quote