I am not getting a response from the .Recordcount in ADODB.Recordset

From: "JohnRoy@xxxxxxxxxxxxx" <johnroy@xxxxxxxxxxxxx>
Date: Sun, 13 Apr 2008 08:12:59 +0100

Hello
I am not getting a response from the .Recordcount in ADODB.Recordset
It opens the file ok and you can see the first record but the .Recordcount
shows -1
Help Please

Set rsEmail_BusinessType = New ADODB.Recordset
rsEmail_BusinessType.Open "Email_BusinessType_Table", ConStr_For_EmailData,
adOpenStatic, adLockOptimistic, adCmdTable
With rsEmail_BusinessType
..MoveFirst
If .RecordCount > 0 Then
Do Until .EOF = True
Combo1.AddItem !BusinessType
.MoveNext
Loop
End If

End With
rsEmail_BusinessType.Close
Set rsEmail_BusinessType = Nothing

.

Follow-Ups:
- Re: I am not getting a response from the .Recordcount in ADODB.Recordset
  - From: Dmitriy Antonov

Prev by Date: Re: Trying to populate a Combo Box from SQL DB
Next by Date: Re: I am not getting a response from the .Recordcount in ADODB.Recordset
Previous by thread: Trying to populate a Combo Box from SQL DB
Next by thread: Re: I am not getting a response from the .Recordcount in ADODB.Recordset
Index(es):
- Date
- Thread

Relevant Pages

Re: getting parameters from stored procedure back into vb code
... See the thread titled "How to get RecordCount in recordset" dated 2/16/2004 ... in this newsgroup. ... There was a response by Samuel Hon that shows an ...
(microsoft.public.vb.database.ado)
Re: not getting a response from the .Recordcount in ADODB.Recordset
... I am not getting a response from the .Recordcount in ADODB.Recordset ... It opens the file ok and you can see the first record but the .Recordcount shows -1 ...
(microsoft.public.vb.database)
Its not that but thanks
... I am not getting a response from the .Recordcount in ADODB.Recordset ... It opens the file ok and you can see the first record but the .Recordcount ... Do Until .EOF = True ...
(microsoft.public.vb.database)
not getting a response from the .Recordcount in ADODB.Recordset
... I am not getting a response from the .Recordcount in ADODB.Recordset ... It opens the file ok and you can see the first record but the .Recordcount ...
(microsoft.public.vb.database)
Re: Recordcount is changing - dont know why
... The RecordCount reflects the number of records loaded at the time. ... Later it updates to reflect the full count. ... After it opens, oepn the Immediate Window and ask Access what's going on, e.g.: ... clicked will open a form that will display all dogs registered by this ...
(comp.databases.ms-access)