table

G

Guest

hello

is there is any way I can rename the fields of a table
from code

Ex: For Table client rename the field F1 ==> ID_Client

Thanks
 
D

Dirk Goldgar

hello

is there is any way I can rename the fields of a table
from code

Ex: For Table client rename the field F1 ==> ID_Client

Thanks
Click to expand...

Something like this air code:

Dim db As DAO.Database
Dim tdf As DAO.TableDef

Set db = CurrentDb
Set tdf = db.TableDefs("Client")

tdf.Fields("F1").Name = "ID_Client"

Set tdf = Nothing
Set db = Nothing
 
Top