Anyone know how to use code to add columns to an existing table?

Hi,
check out the alter command:

Currentdb.Execute "Alter Table TableName Add Column FieldName Text"

You can find more examples searching on UA.
HTH
Good luck

great. Thanks.

One other quick question. how do you define the new column's format to be anything other than text?

Such as integer, double, percent?

Thanks again.

As mentioned search UA.
Instead of text define it as whatever you want. The syntax is:

CurrentDB.Execute "ALTER TABLE tableName ADD COLUMN columnName DataType"

datatype:

DATETIME
Text
BoolField YESNO
Integer
Single
Double
...

HTH
Good luck

thanks1

You're welcome.
Glad I could assist!