Hot Fox: [Access VBA Central] Indirect Reference Table update?

sexta-feira, 21 de maio de 2010

[Access VBA Central] Indirect Reference Table update?

If I have a tableA with columns table_name, column_name , column_value
can I read tableA and use it to add the data items specified in the columns of tableA?

For instance:
table_name col1_name col1_value col2_name col2_value
Employee emp_name Joe Smith birthdate 1/1/50
Employee emp_name Steve Jones birthdate 3/10/53
Transaction Tdate 3/1/2010 Tamount 35.00
Transaction Tdate 3/1/2010 Tamount 25.00

1) The program would open the table specified in the table_name
(That's the easy part since you can open a table specified by a string)
2) Then append a row to the table with the col1_value assigned to
the column specified in col1_name and the col2_value assigned to the column specified in col2_name?

Normally you know the column_names when you write the program and
code:
Table!Column = Value

But can you update a column not knowing it in advance? I.e. can you dynamically compose an sql insert statement and execute it in access?

Thanks,
Jnana