If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Record Number
I have a form on which that I've created navigation buttons (command
buttons) to make it more user friendly for people who are not familiar with Access; therefore, I don't need the navigation bar. But, I would like to see the record number and total number of records. How would I add that to my form so that I can hide the navigation bar entirely. Thanks, Bob |
#2
|
|||
|
|||
Record Number
See The ACCESS Web for some info on this:
http://www.mvps.org/access/forms/frm0026.htm -- Ken Snell MS ACCESS MVP "BobV" wrote in message ... I have a form on which that I've created navigation buttons (command buttons) to make it more user friendly for people who are not familiar with Access; therefore, I don't need the navigation bar. But, I would like to see the record number and total number of records. How would I add that to my form so that I can hide the navigation bar entirely. Thanks, Bob |
#3
|
|||
|
|||
Record Number
Ken,
I hate to sound dumb, but.....two problems....if I try to create a label and don't type anything in it, it disappears. I tried typing text in it, then going to properties and naming the lable "lblNavigate" like the article says, and removing the text I had typed to create the label; then copied the code into the form.....but it wouldn't work because I'm already using the OnCurrent for the navigation buttons I have. It gives me an error "ambiguous name detected: Form_Current. Is it actually supposed to be a label, or am I being too literal in my interpretation. Can you explain?. Thanks, Bob "Ken Snell" wrote in message ... See The ACCESS Web for some info on this: http://www.mvps.org/access/forms/frm0026.htm -- Ken Snell MS ACCESS MVP "BobV" wrote in message ... I have a form on which that I've created navigation buttons (command buttons) to make it more user friendly for people who are not familiar with Access; therefore, I don't need the navigation bar. But, I would like to see the record number and total number of records. How would I add that to my form so that I can hide the navigation bar entirely. Thanks, Bob |
#4
|
|||
|
|||
Record Number
Have a look he
http://www.lebans.com/recnavbuttons.htm RecordNavigationButtons is an MDB containing code to replace the standard Navigation Buttons. The custom buttons exactly emulate the standard navigation bar including the autorepeat property. -- HTH Stephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit. "BobV" wrote in message ... Ken, I hate to sound dumb, but.....two problems....if I try to create a label and don't type anything in it, it disappears. I tried typing text in it, then going to properties and naming the lable "lblNavigate" like the article says, and removing the text I had typed to create the label; then copied the code into the form.....but it wouldn't work because I'm already using the OnCurrent for the navigation buttons I have. It gives me an error "ambiguous name detected: Form_Current. Is it actually supposed to be a label, or am I being too literal in my interpretation. Can you explain?. Thanks, Bob "Ken Snell" wrote in message ... See The ACCESS Web for some info on this: http://www.mvps.org/access/forms/frm0026.htm -- Ken Snell MS ACCESS MVP "BobV" wrote in message ... I have a form on which that I've created navigation buttons (command buttons) to make it more user friendly for people who are not familiar with Access; therefore, I don't need the navigation bar. But, I would like to see the record number and total number of records. How would I add that to my form so that I can hide the navigation bar entirely. Thanks, Bob |
#5
|
|||
|
|||
Record Number
You can put any caption you wish in the label when you create it. This code
will "overwrite" the stored caption when it runs (for displaying, that is). If you are already running code for the Form_Current, then just copy the code steps (not the Private Sub and End Sub steps), and insert them into your already existing code. -- Ken Snell MS ACCESS MVP "BobV" wrote in message ... Ken, I hate to sound dumb, but.....two problems....if I try to create a label and don't type anything in it, it disappears. I tried typing text in it, then going to properties and naming the lable "lblNavigate" like the article says, and removing the text I had typed to create the label; then copied the code into the form.....but it wouldn't work because I'm already using the OnCurrent for the navigation buttons I have. It gives me an error "ambiguous name detected: Form_Current. Is it actually supposed to be a label, or am I being too literal in my interpretation. Can you explain?. Thanks, Bob "Ken Snell" wrote in message ... See The ACCESS Web for some info on this: http://www.mvps.org/access/forms/frm0026.htm -- Ken Snell MS ACCESS MVP "BobV" wrote in message ... I have a form on which that I've created navigation buttons (command buttons) to make it more user friendly for people who are not familiar with Access; therefore, I don't need the navigation bar. But, I would like to see the record number and total number of records. How would I add that to my form so that I can hide the navigation bar entirely. Thanks, Bob |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy an existing record into appropriate tables after modifying. | bdehning | General Discussion | 8 | July 7th, 2004 08:44 AM |
Problems with record locking | Ronny Salomonsen | General Discussion | 0 | June 14th, 2004 09:37 AM |
Job Number Match function??????? | Russ | Worksheet Functions | 3 | April 19th, 2004 06:51 PM |
Excel- Inserting a varying number of rows | Ken Wright | Worksheet Functions | 1 | March 20th, 2004 10:20 PM |
Repost - Referencing values of a record entry, elsewhere! | Russ | Worksheet Functions | 1 | January 21st, 2004 11:27 AM |