Hi Everyone,
Idea: i'd like to add a memo field to an existing table using a macro (or VBA code). i'd like to be able to select which table i want to add the field to.
the reason for all of this is that eventually i want to automate:
1) pulling data from a linked table
2) query/combining it with another table with a common field
3) pull all distinct [team_code] fields from the combined table into a new table
4) *** add the memo field to the new table ***
5) run an (already completed) update query to fill in related values for each [team_code]
come to think of it, if any of you have any brilliant ideas for how to automate or simplify that whole process (macro?) i'd much appreciate hearing your thoughts! thanks guys, you're the best.
Idea: i'd like to add a memo field to an existing table using a macro (or VBA code). i'd like to be able to select which table i want to add the field to.
the reason for all of this is that eventually i want to automate:
1) pulling data from a linked table
2) query/combining it with another table with a common field
3) pull all distinct [team_code] fields from the combined table into a new table
4) *** add the memo field to the new table ***
5) run an (already completed) update query to fill in related values for each [team_code]
come to think of it, if any of you have any brilliant ideas for how to automate or simplify that whole process (macro?) i'd much appreciate hearing your thoughts! thanks guys, you're the best.
