468,107 Members | 1,359 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,107 developers. It's quick & easy.

Show Record Number in Header

I've been searching for a few days and have't found the solution I'm
looking for. I want to create the following in my form's
header...Material: 1 of 15. The first number will change as the user
navigates through the records. I have the total records number
already completed. How can I create a field that will give me the
record number? I think what I need is a record counter, that way if I
delete a record, I will not have any wholes in my numbers. I can not
use an Autonumber field, because my form is based on a query and only
a portion on the total records is used.

Thank you for any assistance,

Chris
Nov 12 '05 #1
2 3467
"chris vettese" <ch**********@yahoo.com> wrote in message
news:40**************************@posting.google.c om...
I've been searching for a few days and have't found the solution I'm
looking for. I want to create the following in my form's
header...Material: 1 of 15. The first number will change as the user
navigates through the records. I have the total records number
already completed. How can I create a field that will give me the
record number? I think what I need is a record counter, that way if I
delete a record, I will not have any wholes in my numbers. I can not
use an Autonumber field, because my form is based on a query and only
a portion on the total records is used.


Where have you been searching? The FAQ site for this group has example code for
doing this.

http://www.mvps.org/access/forms/frm0026.htm
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 12 '05 #2
Rick,

Thank you for the information in regards to my post. I was not
searching the FAQ site. I copied and pasted the code into my form and
added the lblNavigate, but I'm getting an error message. Its telling
me:
Run-time error '438': Object doesn't support this property or method.

Than it goes to the debug screen and highlights this:

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

Is there a reference I need to have checked off for this to work?

Regards,
Chris
"Rick Brandt" <ri*********@hotmail.com> wrote in message news:<bu************@ID-98015.news.uni-berlin.de>...
"chris vettese" <ch**********@yahoo.com> wrote in message
news:40**************************@posting.google.c om...
I've been searching for a few days and have't found the solution I'm
looking for. I want to create the following in my form's
header...Material: 1 of 15. The first number will change as the user
navigates through the records. I have the total records number
already completed. How can I create a field that will give me the
record number? I think what I need is a record counter, that way if I
delete a record, I will not have any wholes in my numbers. I can not
use an Autonumber field, because my form is based on a query and only
a portion on the total records is used.


Where have you been searching? The FAQ site for this group has example code for
doing this.

http://www.mvps.org/access/forms/frm0026.htm

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Mark | last post: by
reply views Thread by Reinhard | last post: by
1 post views Thread by Solo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.