Make Table Query

[digs]

I've got a button on a form that runs a make table query. Is there any way you can stop the prompts coming up to save the user from accepting the prompts.

 

[Jon K]

Method 1: use an Execute method, e.g.

CurrentDb.Execute "qryMakeTable"


Method 2: set warnings to False then True, e.g.

DoCmd.SetWarnings False
DoCmd.OpenQuery "qryMakeTable"
DoCmd.SetWarnings True
.