Appending Fields to a TAble

[harrisw]

How can I create extra fields in an existing table using code?

 

[Mile-O]

Have a look at this thread.

 

[Jacob Mathai]

You can use code :

Docmd.runsql "Alter table tblXXX add column fieldxxx text(20)"

you substitute the table name and field name as needed.


or

Docmd.runsql "Alter table tblxxx add colunn fieldxxx number"

For more ifo, please look at help for ALTER TABLE