Record counter in navigation bar problem !! !!

  • Thread starter MrCC via AccessMonster.com
  • Start date
M

MrCC via AccessMonster.com

Dear All

first of what the excat name for Record counter in navigation bar ?

2nd my problem that such Record counter in navigation bar at subform should
show the total no. of records , Like "..... of 10" ,such word "of 10" doesn't
appear at all except when i click next record button or when i add a new
record
i solved by simple solution at subform load() i use movelast then movefirst ?
?

but i want to know the reason and the right solution ?


Thanks all
bye
 
R

Rick Brandt

MrCC said:
Dear All

first of what the excat name for Record counter in navigation bar ?

2nd my problem that such Record counter in navigation bar at subform
should show the total no. of records , Like "..... of 10" ,such word
"of 10" doesn't appear at all except when i click next record button
or when i add a new record
i solved by simple solution at subform load() i use movelast then
movefirst ? ?

but i want to know the reason and the right solution ?

The combination of the record counter and naviagation buttons is collectively
named "Navigation Buttons". At least that is the name of the property used to
display them or not. In conversation Navigation Buttons and Record Counter
should suffice.

Is the table a linked one or local? Local tables generally display the total
record number immediately, but linked ones might not. Most of the time this is
controlled by how many rows are involved. I have only seen what you are
describing when the number of rows was fairly large (in the thousands). I have
never seen it for only 10 records.
 
M

MrCC via AccessMonster.com

just 2 record !!!!!!!!!!!

yes it is subform of a linked-table linked with the table of the mainform

any tips??


Rick said:
[quoted text clipped - 8 lines]
but i want to know the reason and the right solution ?

The combination of the record counter and naviagation buttons is collectively
named "Navigation Buttons". At least that is the name of the property used to
display them or not. In conversation Navigation Buttons and Record Counter
should suffice.

Is the table a linked one or local? Local tables generally display the total
record number immediately, but linked ones might not. Most of the time this is
controlled by how many rows are involved. I have only seen what you are
describing when the number of rows was fairly large (in the thousands). I have
never seen it for only 10 records.
 
R

Rick Brandt

MrCC said:
just 2 record !!!!!!!!!!!

yes it is subform of a linked-table linked with the table of the
mainform

any tips??

The reason is that Access is smart enough not to pull records it might not have
to. That means that in many cases it will not know how many records there are.

The best solution is to not concern yourself with it. Barring that you have to
force the form to pull all of its records as you have already discovered.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top