Record counter in navigation bar problem !! !!

  • Thread starter Thread starter MrCC via AccessMonster.com
  • Start date 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
 
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 ?
Click to expand...

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.
 
just 2 record !!!!!!!!!!!

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

any tips??


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

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.
Click to expand...
 
MrCC said:
just 2 record !!!!!!!!!!!

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

any tips??
Click to expand...

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.
 
Back
Top