#1
|
|||
|
|||
SQL ADODB.RecordSet Error 91
Hi.
Code:
Dim sTotal As String Dim rsCount As ADODB.Recordset 'This line of error 91 "to the object variable or With block variable not set rsCount.Open "Select Count(Bairro) from [Registros$] where Bairro = 'Centro'" msgbox "O Total de Regsitros é " & rst(0) sTotal = "Select Count(Bairro) from [Registros$] where Bairro = 'Centro'" msgbox "O Total de Regsitros é " & sTotal |
#2
|
||||
|
||||
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") |
#3
|
|||
|
|||
hi.
Thank you!! my fryend!! |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word Visual Basic error - run time error 504 | crazymorton | Word | 11 | 01-13-2012 04:32 AM |
Microsoft office 2010 error 2908 and error 1935 !!!!!!heeeeellpppp!!!!!!!!! | bennypryde | Office | 1 | 01-05-2012 03:33 PM |
getting div error | accablues | Excel | 9 | 07-27-2011 07:58 PM |
Runtime error 5487 - Word cannot complete the save to to file permission error | franferns | Word | 0 | 11-25-2009 05:35 AM |
Receive error cannot open this form because an error occurred in BCM 2007 | bornhusker | Outlook | 0 | 06-01-2009 10:28 AM |