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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access Dcount (multiple criteria) 3
VBA - retrieve data on last create named range from previous inserted named range 0
Access #Error & Excel Pivot 0
How to Populate Data from a table to another 0
DateDiff 4
Conditional SUBTOTAL in XL210 Table 7
Count haracters in table field and update second field if over lim 1

Back
Top