Running a series of Action Queries

  • Thread starter Thread starter Hank Rouse
  • Start date Start date
H

Hank Rouse

Sorry, I have no VBA experience, and the Access Macro prompts me for every
action. So I need to find a better solution.

I'm looking to run a series of Append Queries, then to finish by writing a
delete query.

All Queries are tested and the desired results are achieved. So I would
start with:


DoCmd.SetWarnings False
DoCmd.RunSQL AppendQuery1
DoCmd.RunSQL AppendQuery2
DoCmd.RunSQL AppendQuery3
DoCmd.RunSQL DeleteQuery
DoCmd.SetWarnings True

Thanks in Advance.

Hank
 
Sorry, I found my answer. Just didn't look for SetWarnings in the Actions
drop down list.
 
Back
Top