472,342 Members | 1,448 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,342 software developers and data experts.

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 3704
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Mark | last post by:
I have a working PHP/MySQL application used for data entry. The data entry screen includes a "Save" button. The PHP code for this button looks...
6
by: vasilijepetkovic | last post by:
Hello All, I have a problem with the program that should generate x number of txt files (x is the number of records in the file datafile.txt). ...
4
by: DHRRush | last post by:
I have a simple complaint tracking Db with one main table and one main form for entering data. I need for the users to be able to see the record...
1
by: Galka | last post by:
Hello I have a form to enter names and some other personal information. When a name is entered, it is checked against existing records: maybe,...
26
by: Jimmy | last post by:
ill have a database with 1 table and 3 fields: ID FIRSTNAME LASTNAME (the ID field will be the auto incrementing index) there might be...
0
by: Reinhard | last post by:
Hi, Need some directions on Ajax, UpdatePanel and Gridview to achive the following: I like to show a Gridview with Data ONLY if the user is...
3
by: smugcool | last post by:
Hi, I have created a form in Visual basic 6.0 for adding/updating the change request made by various users. Well i am able to update the record...
2
by: banderson | last post by:
Hello, I have a data entry form for a table with information about buildings and am having a problem making a combo box do what I want. I would like...
0
by: vigneshrao | last post by:
Hi, I have been working on a script that loops through multiple records and sends data (one record per call) to a WS. I am supposed to make a...
0
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
0
better678
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
0
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
0
Oralloy
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.