automatially rename field name with query

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

Guest

Can anyone tell me how to rename a access field name with the name from
records in another table.


Vince
 
One syntax is:

CurrentDb.TableDefs("NameOfTable").Fields("CurrentFieldName").Name =
"NewFieldName"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import Overwrite Data in Table 3
Rename An External Database 6
how to rename a table using field name 1
Renaming control 2
Update field names using a query 6
Changed Field Names and getting a Parameter Query 3
Field name alias does not stick 2
DB2 linked tables have underscore in column names. 0

Back
Top