super difficult question

  • Thread starter Thread starter Gurtz
  • Start date Start date
G

Gurtz

How can I get the number of records in my table in VB code
or otherwise?
:)
Hope I didn't make you think too hard,
Gurtz
 
Oh, and how can I refer to the number of the form's
currently displayed record?

Thanks!
Gurtz
 
Try this:

Dim intCount As Integer
intCount = DCount("[field1]", "table1")

-Cameron Sutherland
 
Depends on what you are loking for with "number of the
form's currently displayed record?". If you want to grab
the record number like the one in the navigation buttons
at the bottom:

Dim intCurrentRecord As Integer
intCurrentRecord = Me.CurrentRecord

-Cameron Sutherland
 
Perfect, Thanks Cameron!
Gurtz
-----Original Message-----
Depends on what you are loking for with "number of the
form's currently displayed record?". If you want to grab
the record number like the one in the navigation buttons
at the bottom:

Dim intCurrentRecord As Integer
intCurrentRecord = Me.CurrentRecord

-Cameron Sutherland
.
Click to expand...
 
Back
Top