How do I automate queries to run themselves from a form?

[MarkMichel]

I have created an access database that has 9 queries to produce my end results. I have create a form that has 9 separate buttons to run each query individually. How can I create 1 button to run all 9 queries consecutively?

[June7]

Have you tried just putting all the code behind the one button?

[ItsMe]

Are they Action queries, like an UPDATE query? Could use VBA behind a click event.

CurrentDB.Execute "Your SQL String HERE"

edit:
@June7 I am thinking embedded Macro via Wizard

[MarkMichel]

Yes, there are create table queries and update data queries.

[MarkMichel]

I was able to make one button run all of the queries. How can I turn off the prompts so that there isn't any user intervention?

[June7]

In VBA

CurrentDB.Execute "UPDATE ..."

If you are using macro, then use

SetWarnings = False
...
SetWarnings = True

Why are you having to create tables?

[MarkMichel]

I am taking data from a main table and manipulating it various times to create the end result. I am a self taught person who doesn't know any other way. I am not sure where to put the code you suggest, Should I provide a copy of my db and you could show me? or is there another way. Really appreciate the help.

[June7]

Are you using macro or VBA?

Can provide db if you want. Follow instructions at bottom of my post.

[MarkMichel]

I have been able to figure it out. Thank you both for the assistance.