RecordsetCount in Access ADO

[Lauren Quantrell]

I've been using this in my MDB projects:

Dim myRecords, myString as string
myRecs = me.recordsetclone.recordcount
myString = "There are " & myRecs & " records in this set."

It works fine in my MDBs, but in my ADO it works fine if there are 100
records or less, but always shows "100" for recordsets larger than
100.

Does anyone know how I can fix this?
lq

[TC]

I don't know about ADO, but in DAO, the recordcount property only returns
the number of records that have been >>accessed from that recordset so
far<<. This is >>not<< necessarily the total number of records in that
recordset. So you should always do a MoveLast on the recordset, before you
assume that recordcount will be the total # of records therein.

Perhaps if your records were being returned in batches of 2100, this would
explain what you see?

HTH,
TC
"Lauren Quantrell" <la*************@hotmail.com> wrote in message
news:47**************************@posting.google.c om...

I've been using this in my MDB projects:

Dim myRecords, myString as string
myRecs = me.recordsetclone.recordcount
myString = "There are " & myRecs & " records in this set."

It works fine in my MDBs, but in my ADO it works fine if there are 100
records or less, but always shows "100" for recordsets larger than
100.

Does anyone know how I can fix this?
lq

[Pieter Linden]

la*************@hotmail.com (Lauren Quantrell) wrote in message news:<47**************************@posting.google. com>...

I've been using this in my MDB projects:

Dim myRecords, myString as string
myRecs = me.recordsetclone.recordcount
myString = "There are " & myRecs & " records in this set."

It works fine in my MDBs, but in my ADO it works fine if there are 100
records or less, but always shows "100" for recordsets larger than
100.

Does anyone know how I can fix this?
lq

Weird. I thoughht if you specified that you wanted a static
recordset, you got a real recordcount, without doing a MoveLast, like
you have to do with DAO...

[Bruce M. Thompson]

> I've been using this in my MDB projects:

Dim myRecords, myString as string
myRecs = me.recordsetclone.recordcount
myString = "There are " & myRecs & " records in this set."

It works fine in my MDBs, but in my ADO it works fine if there are 100
records or less, but always shows "100" for recordsets larger than
100.

Does anyone know how I can fix this?

You must use the "MoveLast" method to get an accurate recordcount for a
recordsetclone:

'********
Dim myRecords As Long, myString as string
'You must move to last record to get accurate recordcount
Me.RecordsetClone.MoveLast
'Retrieve the clone's recordcount
myRecs = me.recordsetclone.recordcount
myString = "There are " & myRecs & " records in this set."
'********

--
Bruce M. Thompson, Microsoft Access MVP
bt******@mvps.org (See the Access FAQ at http://www.mvps.org/access)

NO Email Please. Keep all communications

within the newsgroups so that all might benefit.<<

[Jerry Boone]

What happens is that Access lets the code run even though the form hasn't
loaded all of the rows yet. ADP's allow you to actually stop the loading
with a button on the scrollbar to interrupt the loading of data.

I think I did a requery just before the line you want the recordcount on.

Me.Requery
myRecs = Me.Recorsetclone.Recordcount
"Lauren Quantrell" <la*************@hotmail.com> wrote in message
news:47**************************@posting.google.c om...

I've been using this in my MDB projects:

Dim myRecords, myString as string
myRecs = me.recordsetclone.recordcount
myString = "There are " & myRecs & " records in this set."

It works fine in my MDBs, but in my ADO it works fine if there are 100
records or less, but always shows "100" for recordsets larger than
100.

Does anyone know how I can fix this?
lq

[Lyle Fairfield]

la*************@hotmail.com (Lauren Quantrell) wrote in
news:47**************************@posting.google.c om:

I've been using this in my MDB projects:

Dim myRecords, myString as string
myRecs = me.recordsetclone.recordcount
myString = "There are " & myRecs & " records in this set."

It works fine in my MDBs, but in my ADO it works fine if there are 100
records or less, but always shows "100" for recordsets larger than
100.

Does anyone know how I can fix this?
lq

In some versions of Access
Options->Advanced->Default Max Records
can be set.
If this is set to 100 then only 100 records would be downloaded for the
form and the form's recordsetclone would have only 100 records.

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

[TC]

"Pieter Linden" <pi********@hotmail.com> wrote in message
news:bf**************************@posting.google.c om...

la*************@hotmail.com (Lauren Quantrell) wrote in message

news:<47**************************@posting.google. com>...

I've been using this in my MDB projects:

Dim myRecords, myString as string
myRecs = me.recordsetclone.recordcount
myString = "There are " & myRecs & " records in this set."

It works fine in my MDBs, but in my ADO it works fine if there are 100
records or less, but always shows "100" for recordsets larger than
100.

Does anyone know how I can fix this?
lq

Weird. I thoughht if you specified that you wanted a static
recordset, you got a real recordcount, without doing a MoveLast, like
you have to do with DAO...

NO! I just got burned by this recently. I needed to open a recordset based
on a query, then loop through the recordset, deleting certain records from
one of the tables on which the Query was based. I assumed that opening a
recordset with dbopensnapshot would take a snapshot of all of the relevant
records, thus removing any reliance on the query, or the underlying tables.

Wrong! You must still movelast to populate the whole snapshot. Opening the
recordset with dbopensnapshot *does not*, of itself, populate the whole
snapshot.

TC

[Lauren Quantrell]

This problem is not related to the MaxRecords. I think it's a cursor issue?
lq

Lyle Fairfield <Mi************@Invalid.Com> wrote in message news:<Xn*******************@130.133.1.4>...

la*************@hotmail.com (Lauren Quantrell) wrote in
news:47**************************@posting.google.c om:

I've been using this in my MDB projects:

Dim myRecords, myString as string
myRecs = me.recordsetclone.recordcount
myString = "There are " & myRecs & " records in this set."

It works fine in my MDBs, but in my ADO it works fine if there are 100
records or less, but always shows "100" for recordsets larger than
100.

Does anyone know how I can fix this?
lq

In some versions of Access
Options->Advanced->Default Max Records
can be set.
If this is set to 100 then only 100 records would be downloaded for the
form and the form's recordsetclone would have only 100 records.