If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Run all queries in a group
Is there any way to run all of the queries that are in a group? I could
always make a macro that runs each query but it'd be easier if there was just one action. I have about 40 update queries that need to run. |
#2
|
|||
|
|||
Run all queries in a group
On Tue, 13 May 2008 12:31:00 -0700, CFitz wrote:
Is there any way to run all of the queries that are in a group? I could always make a macro that runs each query but it'd be easier if there was just one action. I have about 40 update queries that need to run. Use code. CurrentDb.Execute "QueryA", dbFailOnError CurrentDb.Execute "QueryB", dbFailOnError CurrentDb.Execute "QueryC", dbFailOnError CurrentDb.Execute "QueryD", dbFailOnError etc. Or if you name each update query in sequential order, i.e. "Query1","Query2","Query3", etc. you can loop through them quite simply: Dim strName as String Dim intX as Integer For intX = 1 to 41 strName = "Query" & intX CurrentDb.Execute strName, dbFailOnError Next intX -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|