Whats the code to do this? and if you wouldn't mind explaining the code thanks?

Well... depending on a number of factors (such as lock type), method of connecting....

assuming that adc is an adodb connection that's connected, and that ars is an adodb recordset that's opened.

ars.RecordCount

Of course you could just do a count of the table:
SELECT Count(*) FROM tablename




____________________________
Everywhere's Local (classifieds, job postings, & more for everycity in the world - user entered)

quote:

---

JLRodgers wrote:
Well... depending on a number of factors (such as lock type), method of connecting....

assuming that adc is an adodb connection that's connected, and that ars is an adodb recordset that's opened.

ars.RecordCount

Of course you could just do a count of the table:
SELECT Count(*) FROM tablename

---

ADODB is the newer than DAO (right now, drastically newer)... as far as "normal records" I'm unaware to what you're referring to... unless it is DAO... but even DAO has a .RecordCount

If you don't know what DAO is either, you'll have to post whatever code you have -- for those are the only two items used for databases.

The only other thing I could think of is you might be referring to a dynamic array (ex: dim tmp() as string : redim tmp(5) ), in which case, you use LBound & UBound (for lower and upper number, typically always 0 for the lower, while the upper is what it's dimensioned or redimensioned for).


[Edited by JLRodgers on 16-10-2005 at 12:18 PM GMT]

____________________________
Everywhere's Local (classifieds, job postings, & more for everycity in the world - user entered)