Add Field to Table using Access Macro

[clevelander]

Hi,

Is there a way to add a permanent field to a table using a macro? I have a number of different tables that I need to add the same field name to, then I update that field based on info in the table, and append them all into one big table. It would be very helpful if I didn't have to go into the design view of each table to add these fields. I'm a novice when it comes to code, but any help would be greatly appreciated!!

Thanks in advance!

[nico5038]

For this you can use a so-called ALTER TABLE query.
When you need to do this for multiple tables you'll need however to grasp the tabels from the currentdb's tabledefs and execute that DDL query in a VBA loop.
The tables will however need to be indentifyable and in general it's faster to do this with a copy/paste (Ctrl+C and Ctrl+V) when selecting the whole line with the field definition in the tabledesign mode.....

Nic;o)

[ADezii]

Hi,

Is there a way to add a permanent field to a table using a macro? I have a number of different tables that I need to add the same field name to, then I update that field based on info in the table, and append them all into one big table. It would be very helpful if I didn't have to go into the design view of each table to add these fields. I'm a novice when it comes to code, but any help would be greatly appreciated!!

Thanks in advance!

This could easily be done with a Macro:
__1 The Macro calls a Public Function
__2 Within this Function is VBA code usin DAO that dynamically creates the Field within the specified Table.

If you wish to continue along this line, please give me more information such as:
__1 The Table Name to contain the newly created Field
__2 The Field Data Type, Size, etc
__3 Any other Parameters that you could think of.