add field to table

[Judy Ward]

I would like to programmatically check to see if a field exists in a table,
and if not, create the field in the table. I must not be searching with the
right key words, because I can't find any help on doing this.

Your help would be appreciated!

Thank you,
Judy

 

[Daniel Pineault]

To check for the existance of a table field check out

http://forums.devarticles.com/micro...-field-exists-in-a-table-using-vba-58559.html

Then to add a new field to a table check out

http://www.eggheadcafe.com/forumarchives/accessmodulescoding/feb2006/post25764605.asp

Another approach can be found at

http://allenbrowne.com/func-DDL.html#CreateTableDDL

Other worthwhile readings on the subject (past posts)

http://www.microsoft.com/office/com...a&p=1&tid=f841115c-08ed-4e0e-ab72-beeb1f81cd9
http://www.microsoft.com/office/com...&p=1&tid=ce449bfa-daa6-433e-b20a-54f06110260f
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Allen Browne]

Loop through the Fields of the Recordset to see if the Name you want exists.

If not, you can add a new one via CreateField(). Example:
http://allenbrowne.com/func-DAO.html#ModifyTableDAO

You can also use DDL to create columns:
http://allenbrowne.com/func-DDL.html#CreateFieldDDL
However, this doesn't let you set some crucial properties such as
AllowZeroLength.