Can I add a field to a table using BASIC?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
waynemb said:
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.
Click to expand...


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.
 
Back
Top