Run create-tab query

[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

 

[PC Datasheet]

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

 

[Guest]

I am from the Access support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue.

Thank you,

Enterprise Project Consulting