Finding Number of fields in a Recordset/Table (1 Viewer)

[benti]

I'm creating a Graph based on a tmp table with a unknown number of Fields, and seaching for a function to find the total number of Fields directly in the Table or by using a Recordset.

 

[WayneRyan]

Benti,

At the least, you can use a function like DCount to count them:

HowMany = DCount("[SomeField]", "SomeTable", "[SomeCriteria] = " & Me.SomeCriteria)

Wayne

 

[tkpstock]

Or you can use

myRecordset.Fields.Count

 

[modest]

Benti,

At the least, you can use a function like DCount to count them:

HowMany = DCount("[SomeField]", "SomeTable", "[SomeCriteria] = " & Me.SomeCriteria)

Wayne

I think this returns the number of records in a given field where the search condition (criteria) exists/is true.

I'd use Chris's way or you can manually do the same thing as chris

Dim lngCount As Long
lngCount = 0
For Each fld in rs.Fields
    lngCount = lngCount + 1
Next

rs is your recordset variable and fld is a recordset field variable

 

[benti]

This was what I looked for.
Thanks a lot to you all!

 

[WayneRyan]

Modest,

Thanks, I totally misread that. Oops!

Wayne