By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,946 Members | 697 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,946 IT Pros & Developers. It's quick & easy.

Record Number with a twist

P: n/a
Experts,
I need your help in this tricky delima.

FormA without record number at the bottom but has a customized record
numbering with the following codes for "lblNavigate" label:

If Me.NewRecord Then
Me!lblNavigate.Caption = "New Record"
Else
With Me.RecordsetClone
.Bookmark = Me.Bookmark
Me!lblNavigate.Caption = "Record " & _
.AbsolutePosition + 1 _
& " of " & .RecordCount
End With
End If

The records are sorted decending, showing most recent dated record on
top.

If I have 3 records dated 01/01/05 (record1), 0/01/05(record2) &
03/01/05(record3) respectively, when this form is open, record3 will
show. When I hit acNext, it will go to record2; another acNext will
bring me to record1. The above code will then show record3 as Record
1/3, record2 as Record 2/3 and record1 as record 3/3. I know this is
true, but is there a way to trick it so that it is easier on "human"
mind? i.e. record3 as Record 3/3, record2 as Record 2/2 and record1 as
Record 1/1.

I hope I explained this well enough for some insight. Thanks again.

P.S.: If I sort this record Decending, the numbering is correct, but I
wanted the most recent dated record on top. Is there another way to
accomplish this?

Sincerely,
Perry

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"P.S.: If I sort this record Decending, the numbering is correct, but I

wanted the most recent dated record on top. Is there another way to
accomplish this? "

I am sorry, I mean "If I sort these records in Ascending order, the
numbering is correct..."

Perry

Nov 13 '05 #2

P: n/a
How about...

Me!lblNavigate.Caption = "Record " & _
.RecordCount - .AbsolutePosition _
& " of " & .RecordCount

....?

Nov 13 '05 #3

P: n/a
Gord,
This is exactly what I wanted, thank you.

Perry

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.