var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Transferring data between Access tables using VBA
I would like to take three fields from one table, and append them to three fields in another table. In this case, the field names may differ.
Can anyone oplease advise VBA coding to go about this?
All suggestions and pointers gratefully received
Jill ( an Access newby)
It would be simplest to create an append query to do it. If you want to use VBA, you'd have to open recordsets on each table, and use the values from one to add to the other.
Many thanks Paul. Sounds good.
can you please advise generalised code statement to run a Query from VBA?
Thanks Paul. Found the exact one I was after: