G
Guest
Does anyone know how to add or delete a field from a table using VBA?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Allen Browne
Method 1: DDL
Execute a query statement such as:
"ALTER TABLE MyTable ADD COLUMN MyColumn TEST;"
"ALTER TABLE MyTable DROP COLUMN MyColumn;"
Method 2: DAO
Use CreateField() and then Append to the Fields collection of the TableDef.
Delete the Field from the Fields collection of the TableDef
Method 3: ADOX
Declare a new ADOX.Column, and Append to the Columns of the Table.
Use method 1 for a quick and simple approach.
Use method 2 if you want fine control over the properties of the new field.
Use method 3 if you are a maschochist. (ADOX is very buggy, with different
bugs in different versions so you never know what you will end up with.)
Execute a query statement such as:
"ALTER TABLE MyTable ADD COLUMN MyColumn TEST;"
"ALTER TABLE MyTable DROP COLUMN MyColumn;"
Method 2: DAO
Use CreateField() and then Append to the Fields collection of the TableDef.
Delete the Field from the Fields collection of the TableDef
Method 3: ADOX
Declare a new ADOX.Column, and Append to the Columns of the Table.
Use method 1 for a quick and simple approach.
Use method 2 if you want fine control over the properties of the new field.
Use method 3 if you are a maschochist. (ADOX is very buggy, with different
bugs in different versions so you never know what you will end up with.)