Running multiple queries

[kerrigirrl]

is it possible to run 10+ queries, (append-select-update-makenewtable...) from the same submit button? if one takes 30 seconds or so to run, will it wait before it goes on to the next one? will it let you answer the "this will append..." confirmations?

thanks in advance,
kerri

 

[LonnieJohnson]

Yes...yes... and yes.

The code runs sequentially processing each query one at a time. This brings up the fact that if each query is dependent upon the one before, your process will come to a halt. ljprodev@yahoo.com
Professional Development
MS Access Applications