Need to know the number revealed by the next record button

[Telesphore]

I created a form (frmStudents) whose source control is tblStudents.
In the table, when I click the next record button, I can the next record
number.
I would like to see that number in the form?
I tried "=[CurrentRecord]" in a control box of the form, but it didn't work


Thanks for the help

 

[Telesphore]

Thank you,

I created the form without the assistant, so that the buttons didn't appear.
I suppose I must know recreate it with the assistant, using the simple
column propiety, unless I could install the buttons in another manner.

I do not see the problem
if you build a form on a table tblStudent with the columnar wizard you

will see the record navigation buttons and the record number on the bottom
of the form.

Please expain a little better your problem
--
Paolo

I created a form (frmStudents) whose source control is tblStudents.
In the table, when I click the next record button, I can the next record
number.
I would like to see that number in the form?
I tried "=[CurrentRecord]" in a control box of the form, but it didn't work


Thanks for the help

 

[Allen Browne]

1. Open your form in design view.

2. Open the Properties box (View menu).

3. Click the Format tab of the Properties box.

4. Set the Navigation Buttons property to Yes.

If you do not see the Navigation Buttons property, you are looking at the
properties of a control (such as a text box) instead of the properties of
the form.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Thank you,

I created the form without the assistant, so that the buttons didn't appear.
I suppose I must know recreate it with the assistant, using the simple
column propiety, unless I could install the buttons in another manner.

I do not see the problem
if you build a form on a table tblStudent with the columnar wizard you

will see the record navigation buttons and the record number on the bottom
of the form.

Please expain a little better your problem
--
Paolo

I created a form (frmStudents) whose source control is tblStudents.
In the table, when I click the next record button, I can the next record
number.
I would like to see that number in the form?
I tried "=[CurrentRecord]" in a control box of the form, but it didn't work


Thanks for the help

 

[Telesphore]

Thank you so much. That was an easy one!
My french version of Access has a ambiguous name for the Navigation Buttons.

Thanks again

1. Open your form in design view.

2. Open the Properties box (View menu).

3. Click the Format tab of the Properties box.

4. Set the Navigation Buttons property to Yes.

If you do not see the Navigation Buttons property, you are looking at the
properties of a control (such as a text box) instead of the properties of
the form.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Thank you,

I created the form without the assistant, so that the buttons didn't appear.
I suppose I must know recreate it with the assistant, using the simple
column propiety, unless I could install the buttons in another manner.

I do not see the problem
if you build a form on a table tblStudent with the columnar wizard

you
will see the record navigation buttons and the record number on the bottom
of the form.

Please expain a little better your problem
--
Paolo


:

I created a form (frmStudents) whose source control is tblStudents.
In the table, when I click the next record button, I can the next record
number.
I would like to see that number in the form?
I tried "=[CurrentRecord]" in a control box of the form, but it

didn't
work

Thanks for the help

 

[Telesphore]

I am back again...

The result is not what I hoped for.

Instead of giving me let's say 467, when the form appears and if there is no
student name, the result is 0; if there is a student name, the result is 1.

1. Open your form in design view.

2. Open the Properties box (View menu).

3. Click the Format tab of the Properties box.

4. Set the Navigation Buttons property to Yes.

If you do not see the Navigation Buttons property, you are looking at the
properties of a control (such as a text box) instead of the properties of
the form.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Thank you,

I created the form without the assistant, so that the buttons didn't appear.
I suppose I must know recreate it with the assistant, using the simple
column propiety, unless I could install the buttons in another manner.

I do not see the problem
if you build a form on a table tblStudent with the columnar wizard

you
will see the record navigation buttons and the record number on the bottom
of the form.

Please expain a little better your problem
--
Paolo


:

I created a form (frmStudents) whose source control is tblStudents.
In the table, when I click the next record button, I can the next record
number.
I would like to see that number in the form?
I tried "=[CurrentRecord]" in a control box of the form, but it

didn't
work

Thanks for the help

 

[Allen Browne]

The form gives you 467 records?
And then it reduces to 1 or zero? When you filter the form or something?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I am back again...

The result is not what I hoped for.

Instead of giving me let's say 467, when the form appears and if there is no
student name, the result is 0; if there is a student name, the result is 1.

1. Open your form in design view.

2. Open the Properties box (View menu).

3. Click the Format tab of the Properties box.

4. Set the Navigation Buttons property to Yes.

If you do not see the Navigation Buttons property, you are looking at the
properties of a control (such as a text box) instead of the properties of
the form.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Thank you,

I created the form without the assistant, so that the buttons didn't appear.
I suppose I must know recreate it with the assistant, using the simple
column propiety, unless I could install the buttons in another manner.

I do not see the problem
if you build a form on a table tblStudent with the columnar wizard you
will see the record navigation buttons and the record number on the bottom
of the form.
Please expain a little better your problem
--
Paolo


:

I created a form (frmStudents) whose source control is tblStudents.
In the table, when I click the next record button, I can the next record
number.
I would like to see that number in the form?
I tried "=[CurrentRecord]" in a control box of the form, but it didn't
work


Thanks for the help

 

[Telesphore]

The form (frmStudent) doesn't give me 467 records. But I know that the table
(tblStudent) has 467 records.

When I open the form (frmStudent) with a command button on the form
(frmStudentChoice) using the Combo list (cboChoixÉtudiant) to choose a
student name, the result is 1 in the property control source
(=RecordsetClone.RecordCount) of the frmStudent control box NumEnreg; if I
open the frmStudent without choosing a student name (leaving the Combo list
blank), the result is 0.

With the navigation buttons active, the result is 1 in each case.

The form gives you 467 records?
And then it reduces to 1 or zero? When you filter the form or something?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I am back again...

The result is not what I hoped for.

Instead of giving me let's say 467, when the form appears and if there

is

no
student name, the result is 0; if there is a student name, the result is 1.

1. Open your form in design view.

2. Open the Properties box (View menu).

3. Click the Format tab of the Properties box.

4. Set the Navigation Buttons property to Yes.

If you do not see the Navigation Buttons property, you are looking at the
properties of a control (such as a text box) instead of the properties of
the form.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.
Thank you,

I created the form without the assistant, so that the buttons didn't
appear.
I suppose I must know recreate it with the assistant, using the simple
column propiety, unless I could install the buttons in another manner.

I do not see the problem
if you build a form on a table tblStudent with the columnar

wizard
you

will see the record navigation buttons and the record number on the bottom
of the form.
Please expain a little better your problem
--
Paolo


:

I created a form (frmStudents) whose source control is tblStudents.
In the table, when I click the next record button, I can the next
record
number.
I would like to see that number in the form?
I tried "=[CurrentRecord]" in a control box of the form, but it didn't
work


Thanks for the help

 

[Allen Browne]

The RecordsetClone.RecordCount shows the number or records accessed so far,
which will be 1 when the form is first loaded. You may need to move to the
last record, and then Recalc to get it to show the true count.

OTOH, the nav. buttons show "1 of " with the total number missing until it
has loaded all records. When that happens you see "1 of 467" if all records
are loaded - fewer if the form is filtered.

When there is no record, the RecordCount will show zero, whereas the nav
buttons will show 1 because it counts the new record.

Not sure what else is happening for you.

 

[Telesphore]

Thank you,

Because the form is filtered, it always shows 1 on 1 in the navigation
butttons. So the secretaires will have to open the table first to note the
total records number, when they need to fill in the data of a new student.
They need that number to create a new student code, for example 04-1467.