Select Field Names from Table 1

[Fattire]

I keep searching but can't find this question ever being asked.

How do I extract the field names, data type, and field description from an Access table via SQL or a Query? I don't see any table column name data in the Msys tables.

 

[dhookom]

You don't. This requires code or the Documenter or some other tool.

Duane
Hook'D on Access
MS Access MVP

 

[MajP]

this function returns the field names seperated by a semicolon.

Public Function getFieldNames(tableName As String) As String
  Dim rs As DAO.Recordset
  Dim fld As DAO.Field
  Set rs = CurrentDb.OpenRecordset(tableName)
  For Each fld In rs.Fields
    getFieldNames = getFieldNames & fld.Name & ";"
  Next fld
  getFieldNames = Left(getFieldNames, Len(getFieldNames) - 1)
End Function

You can show this in a combo or listbox:
[/code]
Private Sub Form_Load()
With Me.Combo0
.RowSource = getFieldNames("tblPersonnel")
.RowSourceType = "value list"
End With
End Sub
[/code]

or you can use the split function on the results from above to split the results into an array. Then you could populate a table with the results.

This does not help you with a query that shows the field names.

 

[Fattire]

wow you are awesome... well done, thank you