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

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

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

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

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