Run create-tab query

  • Thread starter Thread starter Hai Ly Hoang
  • Start date Start date
H

Hai Ly Hoang

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
 
Back
Top