Change a fieldname

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to change a field name of a table using VBA.

Any code samples would be much appreciated.

Thank you,
Mark
 
Hi, Mark.
I would like to change a field name of a table using VBA.
Click to expand...

Try syntax such as the following:

CurrentDb().TableDefs("tblJobs").Fields("Client").Name = "ClientName"

.... where tblJobs is the name of the table, Client is the current name of
the field, and ClientName is the desired name of this field.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that the first and
best answers are often given to those who have a history of rewarding the
contributors who have taken the time to answer questions correctly.
 
Back
Top