Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Counting Records in a Recordset 1

Status
Not open for further replies.
solo7

solo7

Technical User
Mar 14, 2001
243
NO
I have a recordset to which i have assigned a sql statement. This is in a loop and the resultant records returned will be either one record or no records. I am trying to use the <recordset>.RecordCount property of the recordset to 'catch' the records with a value - but for every pass of the loop the RecordCount is -1, even when a single record is present.

Can anyone shed a little light on this??

solo7 [thumbsup2]
 
Sort by date Sort by votes
Test the .BOF and the .EOF property of the recordset.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
Works a treat.

many thanks PHV

solo7 [thumbsup2]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MacroAlan
  • Locked
  • Question
Empty recordset stops 1
Replies
3
Views
445
Andrzejek
Andrzejek
FrankMars
  • Locked
  • Question
Exporting Records to Excel 1
Replies
6
Views
809
Andrzejek
Andrzejek
M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
4K
SoftwareRT
SoftwareRT
Zyborg
  • Locked
  • Question
Using a variable as reference to a form
Replies
5
Views
807
Zyborg
Zyborg
V
  • Locked
  • Helpful tip
Capture Shift Key if Pressed on A form
Replies
3
Views
674
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top