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

Displaying Record Number on Form

P: n/a
I need to display the record number on a form - replacing the Access
Navigation Buttons.

I found a routine on Access Web that is supposed to work but when I use it I
am told that "Object doesn't support this property or method"

The code it uses is placed on the on Current Event and is as follows:

With Me.RecordsetClone
.Bookmark = Me.Bookmark
Me.lblNavigate.Caption = "Record " & _
.CurrentRecord _
& " of " & .RecordCount
End With

This produces the error...

I am using Access 2002. Is there a way to do this in Access 2002?

Mike
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Newer versions of Access have exposed the form's recordset so that you can use it directly
instead of creating a clone first.

Me.lblNavigate.Caption = "Record " & _
Me.CurrentRecord & " of " _
Me.Recordset.RecordCount

--
Wayne Morgan
Microsoft Access MVP
"Mike" <re******@hotmail.com> wrote in message news:3f******@dnews.tpgi.com.au...
I need to display the record number on a form - replacing the Access
Navigation Buttons.

I found a routine on Access Web that is supposed to work but when I use it I
am told that "Object doesn't support this property or method"

The code it uses is placed on the on Current Event and is as follows:

With Me.RecordsetClone
.Bookmark = Me.Bookmark
Me.lblNavigate.Caption = "Record " & _
.CurrentRecord _
& " of " & .RecordCount
End With

This produces the error...

I am using Access 2002. Is there a way to do this in Access 2002?

Mike

Nov 12 '05 #2

P: n/a
Thanks Wayne... works a treat.

Mike

"Wayne Morgan" <co***************************@hotmail.com> wrote in message
news:vg******************@newssvr31.news.prodigy.c om...
Newer versions of Access have exposed the form's recordset so that you can use it directly instead of creating a clone first.

Me.lblNavigate.Caption = "Record " & _
Me.CurrentRecord & " of " _
Me.Recordset.RecordCount

--
Wayne Morgan
Microsoft Access MVP
"Mike" <re******@hotmail.com> wrote in message

news:3f******@dnews.tpgi.com.au...
I need to display the record number on a form - replacing the Access
Navigation Buttons.

I found a routine on Access Web that is supposed to work but when I use it I am told that "Object doesn't support this property or method"

The code it uses is placed on the on Current Event and is as follows:

With Me.RecordsetClone
.Bookmark = Me.Bookmark
Me.lblNavigate.Caption = "Record " & _
.CurrentRecord _
& " of " & .RecordCount
End With

This produces the error...

I am using Access 2002. Is there a way to do this in Access 2002?

Mike


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.