Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Rename table field 2

Status
Not open for further replies.
samotek

samotek

Technical User
May 9, 2005
197
BG
Can i rename table field by code? For example, the field Sys to be renamed as Tyb ?
 
Sort by date Sort by votes
Hi
Yes, you can use the TableDef. For example:
Code: 
Dim tdf As TableDef
Dim db As Database
Set db = CurrentDb
Set tdf = db.TableDefs("tblTable")
tdf.Fields("NameOfField").Name = "NewName"

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

A
  • Locked
  • Question
Print Table attachment
Replies
2
Views
194
andre.meyer
A
ameedoo3000
  • Question
Clear all table contents without deleting records
Replies
15
Views
657
ameedoo3000
ameedoo3000
OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
4K
OCM
OCM
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
745
renigar
renigar
clevercat88
  • Locked
  • Question
Field in table will not filter - info update
Replies
0
Views
236
clevercat88
clevercat88

Part and Inventory Search

Sponsor

Back
Top