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

Show Record Number in Header

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
"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

P: n/a
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.