RecordCount Property

  • Thread starter Thread starter JamesJ
  • Start date Start date
J

JamesJ

Hi. I had code to display the number of records using the RecordCount
property in a label but have misplaced it.
The code example in Microsoft Visual Basic help was way more than I needed.
Can someone point me to an example?

Any help will be appreciated,
James
 
YourLabelName.Caption = "Record " & CurrentRecord & " Of " &
RecordsetClone.RecordCount & " Records"

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
 
Hi. I had code to display the number of records using the RecordCount
property in a label but have misplaced it.
The code example in Microsoft Visual Basic help was way more than I needed.
Can someone point me to an example?

Any help will be appreciated,
James
Click to expand...

If you use an unbound Text control:
=[RecordsetClone].[RecordCount]

If you wish to display the count in a Label control, you'll need to
use VBA code.

Me!LabelName.Caption = Me.[RecordsetClone].[RecordCount]
 
In a label but can't get it to work.
Should the code be in the On Current of the form?

James

fredg said:
Hi. I had code to display the number of records using the RecordCount
property in a label but have misplaced it.
The code example in Microsoft Visual Basic help was way more than I
needed.
Can someone point me to an example?

Any help will be appreciated,
James
Click to expand...

If you use an unbound Text control:
=[RecordsetClone].[RecordCount]

If you wish to display the count in a Label control, you'll need to
use VBA code.

Me!LabelName.Caption = Me.[RecordsetClone].[RecordCount]
Click to expand...
 
In a label but can't get it to work.
Should the code be in the On Current of the form?

James

fredg said:
Hi. I had code to display the number of records using the RecordCount
property in a label but have misplaced it.
The code example in Microsoft Visual Basic help was way more than I
needed.
Can someone point me to an example?

Any help will be appreciated,
James
Click to expand...

If you use an unbound Text control:
=[RecordsetClone].[RecordCount]

If you wish to display the count in a Label control, you'll need to
use VBA code.

Me!LabelName.Caption = Me.[RecordsetClone].[RecordCount]
Click to expand...
Click to expand...

Yes, the Current event should work fine.
 
Back
Top