Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBA Coding to Append a table to another

Status
Not open for further replies.

Preacher1954

Programmer
Mar 13, 2012
4
ZA
Good day to you all.
I need to do VBA coding where I want to open a table and append it to another. The reason is that in VBA I will be adding in the table names according to the user signed on.

In a normal append query the table names are mentioned, coded if you wish in the query. I want to override it programmatically.

I am new to the VBA coding scenario, hence the help requested to input a table and append it.

Much appreciated.
 
I would still use an append query but I would build the query in code and run it.

Can you provide the SQL of your append query and suggest what needs to get changed and where the value comes from?

Duane
Hook'D on Access
MS Access MVP
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top