Run query from button

[Garry]

Is there an easy way of running several queries (12ish) one after the other
from a button

 

[XPS350]

Yes there is. Put the folowing commands under the button:
DoCmd.OpenQuery "Query01"
DoCmd.OpenQuery "Query02"
DoCmd.OpenQuery "Query03"
DoCmd.OpenQuery "Query04"
..
..
..
..
..
DoCmd.OpenQuery "Query99"


Peter
http://access.xps350.com

 

[John W. Vinson]

Is there an easy way of running several queries (12ish) one after the other
from a button

I'd be inclined to use the Execute method in VBA code: it avoids prompts "do
you really want to run this query?" and provides for specifying parameters.
See the VBA help for the Execute method of the Querydef object for sample
code, or post back.

I've occasionally created a table with fields for a query name, sequence
number, and sometimes other fields and used a VBA loop through a recordset to
run a set of queries in order.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[Garry]

That's great thank,s for your time