Record Number

[BobV]

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 Snell]

See The ACCESS Web for some info on this:
http://www.mvps.org/access/forms/frm0026.htm

 

[BobV]

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

 

[Stephen Lebans]

Have a look here:
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.

 

[Ken Snell]

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.