Run queries from VB

[Guest]

How would I run a make table query confirming all the yes dialog boxes using vb.

 

[BP]

docmd.setwarnings true 'Will let u see all the dialog box
DoCmd.OpenQuery RunQueryName, acViewNormal, acEdit
(RunQueryName is the name of the maketable query as
string)

 

[Juan M. Afan de Ribera]

I supose that what you want is to not see the warning messages that will
appear in every action query. If so, have a look at

http://www.mvps.org/access/queries/qry0012.htm

--
Saludos desde Barcelona
Juan M. Afan de Ribera
<MVP Ms Access>
http://www.juanmafan.tk
http://www.clikear.com/webs4/juanmafan