
This Access VBA tutorial explains how to run Query and run Action Query in Access VBA.
You may also want to read:
Access VBA delete Table records with SQL using DoCMD.RunSQL Method
Access VBA run Query or Action Query
Imagine you have to run 10 Action Query (e.g. Create Table, Update, Delete Table) in a row to get the final result, you have to run each Action Query one by one and the most annoying part is to click the confirmation dialogs. With Access VBA we can run a series of Action Qu...
Read More