table

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
Back
Top