How to get field names of a table 2

[dbadmin]

Hi,

I am using access 97. There is a requirement which is to get the column names of a table. Is there any way to get it?

Thanks in advance
dbadmin

 

[Remou]

It is a long time since I use 97, but I think you should be able to get field names from a TableDef.

Dim tdf As TableDef
Dim db As Database
Dim fld

Set db = CurrentDB
Set tdf = d.TableDefs([i]"TableName"[/i])
For Each fld in tdf.Fields
   Debug.Print fld.Name
Next

Or there abouts.

You should also be able to get a field list from a recordset.

 

[PHV]

Or from a combobox with RowSourceType set to "Field list"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dbadmin]

Thank you!

dbadmin