records number shows in label

[mathanraj76]

Hi..



I need help

How to show records number on label in ms access

For an example
Total records in my table 20
I'm in records number 5
So..it's should show me "5 of records 20" in the label

when i click next button,previous button,first button and last button the records number must follow up ..


Thanks
MathanRaj

[Missinglinq]

First you have to force Access to load the entire RecordSet, something the Access Gnomes don't always do when a Form first opens:

Private Sub Form_Load()
  DoCmd.GoToRecord , , acLast
  DoCmd.GoToRecord , , acFirst
End Sub

Then to update the count as you move from Record-to-Record:

Then

Private Sub Form_Current()
  Me.LabelName.Caption = "Record  " & CurrentRecord & "  Of  " & RecordsetClone.RecordCount & "  Records"
End Sub

Linq ;0)>

[mathanraj76]

First you have to force Access to load the entire RecordSet, something the Access Gnomes don't always do when a Form first opens:

Private Sub Form_Load()
  DoCmd.GoToRecord , , acLast
  DoCmd.GoToRecord , , acFirst
End Sub

Then to update the count as you move from Record-to-Record:

Then

Private Sub Form_Current()
  Me.LabelName.Caption = "Record  " & CurrentRecord & "  Of  " & RecordsetClone.RecordCount & "  Records"
End Sub

Linq ;0)>

Thanks ..
You have solved my problems
I'm still new in ms access and I need to learn more with expert like you..
Once again Thanks..

[Missinglinq]

Glad we could help!

Good luck with your project!

Linq ;0)>