Can I add a field to a table using BASIC?

[Guest]

I'm wondering if there's some way to add a field to a table using BASIC,
rather than the normal way of opening the table in design view by hand, etc.

 

[Marshall Barton]

I'm wondering if there's some way to add a field to a table using BASIC,
rather than the normal way of opening the table in design view by hand, etc.

For sure you can use DAO's CreateField method.

Alternatively, you can use the Execute method to run an
ALTER TABLE query.

Check Help to see which way is best in your situation, and
come on back if you run into a problem.