• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 324
  • Last Modified:

MSAccess Recordset

I am beginner :(
Is there Any way to check the number of rows in open recordset.
I don't want to count it, but read from variable ?
Thansk for any answer
0
Madzia
Asked:
Madzia
1 Solution
 
LopcioCommented:
Simply.
If you have variable fo example

dim rs as Recordset

and it is open

you may check this number in this way:

rs.RecordCount.

This keeps a number of records in opened RecordSet
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now