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?
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?
Have you tried just putting all the code behind the one button?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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
Yes, there are create table queries and update data queries.
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?
In VBA
CurrentDB.Execute "UPDATE ..."
If you are using macro, then use
SetWarnings = False
...
SetWarnings = True
Why are you having to create tables?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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.
Are you using macro or VBA?
Can provide db if you want. Follow instructions at bottom of my post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I have been able to figure it out. Thank you both for the assistance.