|
 |
access thread: Current Record Number
Message #1 by "Aaron Dennis" <aaron@r...> on Thu, 27 Feb 2003 11:21:05
|
|
Hello People,
Does anyone know how to display the number for the current record in a
form? I would also like to display the number of the total amount of
records in a given form.
Thanks In Advance.
Aaron
Message #2 by "Gregory Serrano" <SerranoG@m...> on Thu, 27 Feb 2003 13:27:24
|
|
Aaron,
<< Does anyone know how to display the number for the current record in a
form? >>
Me.CurrentRecord will give you the number of the current record that the
form is sitting on.
<< I would also like to display the number of the total amount of records
in a given form. >>
A quickie way I count records is this:
intNoRec = DCount("[Primary Key]", "tblMyTable", _
"[Primary Key] Is Not Null")
Greg
Message #3 by Beth Moffitt <BethMoffitt@i...> on Thu, 27 Feb 2003 08:52:10 -0600
|
|
I like to use the following for total number of records in a recordset:
On the form place a text box called RecCount
On Form_Current use:
Me.Dynaset.MoveLast
Me!RecCount = Me.Dynaset.RecordCount & " Records"
The text box will display the total number of records in the recordset.
Beth
-----Original Message-----
From: Gregory Serrano [mailto:SerranoG@m...]
Sent: Thursday, February 27, 2003 7:27 AM
To: Access
Subject: [access] Re: Current Record Number
Aaron,
<< Does anyone know how to display the number for the current record in a
form? >>
Me.CurrentRecord will give you the number of the current record that the
form is sitting on.
<< I would also like to display the number of the total amount of records
in a given form. >>
A quickie way I count records is this:
intNoRec = DCount("[Primary Key]", "tblMyTable", _
"[Primary Key] Is Not Null")
Greg
|
|
|
View Cart
