Run create-tab query

Hi,
I have several Create-tab queries (about 5). Now , i want to run (create new
table with them) them all.
How to do that ? Certainly not by click each query and issuses run command
for each of them (because i have to requery all of them a lot of time)

Thank in advance

Put the following code in the Click event of a button or other appropriate
event:
DoCmd.SetWarnings False
DoCmd.OpenQuery "Query1"
DoCmd.OpenQuery "Query2"
"
"
DoCmd.OpenQuery "Query5"
DoCmd.SetWarnings True

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com


"Hai Ly Hoang" wrote in message
...
Hi,
I have several Create-tab queries (about 5). Now , i want to run (create new
table with them) them all.
How to do that ? Certainly not by click each query and issuses run command
for each of them (because i have to requery all of them a lot of time)

Thank in advance