Counting columns of a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
Please help me.
I need to know the function name used to know the amount of columns of any
table.
Saludos.
 
Eliud said:
I need to know the function name used to know the amount of columns of any
table.
Click to expand...


THere is no function to do that. You could create one
easily enough though.

Public Function FieldCount(tbl As String) As Integer
FieldCount = CurrentDb().TableDefs(tbl).Fields.Count
End Function
 
Back
Top