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

To check for the existance of a table field check out

http://forums.devarticles.com/micros...vba-58559.html

Then to add a new field to a table check out

http://www.eggheadcafe.com/forumarch...st25764605.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/comm...72-beeb1f81cd9
http://www.microsoft.com/office/comm...a-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.



"Judy Ward" wrote:

> 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

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Judy Ward" <(E-Mail Removed)> wrote in message
news:9560C547-025C-45AE-8601-(E-Mail Removed)...
>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