Last Record in a Resultset

[Guest_imported]

I'm displaying a list of links from Access. Each link needs a linebreak under it EXCEPT for the last link. Is there a way to identity the last record in a resultset? I know I could always use a COUNT(*) query to get the last record but I figured there must be an easier way!

 

[BKQc]

Depending on the cursor and lock of your recordset, you can use the .recordCount property of the recordset object

(

http://msdn.microsoft.com/library/en-us/ado270/htm/mdprorecordcount.asp?frame=true)

 

[Guest_imported]

weird, it returns "-1" (thus meaning im using the wrong cursor. What's weird is I tried using all of the adOpens...

 

[BKQc]

What is your Database on?

 

[Guest_imported]

access

 

[BKQc]

Have you tried this line after setting the cursor to adOpenStatic?

If objRecordset.Supports(adBookmark) Or objRecordset.Supports(adApproxPosition) Then
	' RecordCount will work!
End If

It this doesn't work either, a bad trick is to do a moveFirst, moveLast then call the recordCount

 

[BKQc]

Could you post your code here?