Running a series of Action Queries

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
 
H

Hank Rouse

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 Verses 2003 - passing of variables. 2
append update delete query code question 2
Excel Import via VBA - how can I improve my horrible code?? 0
run multiple queries in VBA 5
Problem running an Action Query with VBA 4
First Effort Using VBA Code on ComboBox 3
Problems with action queries in a macro group 5
Deleting a Form & SubForm Record 1

Top