Append query on click

[marleyuk]

Hi,

I would like to make an append query to piece together multiple tables into a holding table, once the command button is clicked.

Can anyone advice a) how to make an append query in vba, b) Does anyone know how to call an append query on click of a command button?

Thanks,
Ian.

 

[namliam]

Create an append query in the designer, change the view to SQL and you know how to write it

Currentdb.Execute "Append query here"

or you can use docmd.runsql while (de)activating setwarnings around it unless you want to see the "About to append x records bla bla" access message.