Help!! VB Code to run multiple queries in sequence in Access

[pinecrest515]

Hi,



I am relatively new to VB on MS Access, and would like to consult forumers on a problem I am facing.

I developed a series of SQL queries, where, when run sequentially, will get me what I want. However, my client demands something simliar, where she can just click one button and get the results from running multiple queries.

Question: How can I construct a program (VB?) that allows multiple SQL queries to run sequentially on MS Access? One of the SQL queries prompts an input parameter.

I really don't know how to use VB to program on Access, so any pointers, instructions, and syntax help will be great!

Thank you in advance!

[jzwp11]

To what types of queries are you referring: SELECT, Update, Append, Delete?

[ajetrumpet]

To what types of queries are you referring: SELECT, Update, Append, Delete?

UNIONS!

[zyltar]

Hi,

The command to run queries which exist in the front en is

docmd.openquery("queryname")

If you don't want to have the confirmation box for action queries
put before

docmd.setwarnings false
docmd.openquery("queryname")
docmd.setwarnings true

Hope it helps.