super difficult question

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
 
G

Gurtz

Oh, and how can I refer to the number of the form's
currently displayed record?

Thanks!
Gurtz
 
C

Cameron Sutherland

Try this:

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

-Cameron Sutherland
 
C

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
 
G

Gurtz

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