RecordCount Property

[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

 

[missinglinq via AccessMonster.com]

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

 

[fredg]

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

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]

 

[JamesJ]

Works fine. Thanks

James

 

[JamesJ]

In a label but can't get it to work.
Should the code be in the On Current of the form?

James

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

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]

 

[fredg]

In a label but can't get it to work.
Should the code be in the On Current of the form?

James

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

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]

Yes, the Current event should work fine.