G Guest Oct 27, 2003 #1 How would I run a make table query confirming all the yes dialog boxes using vb.
B BP Oct 27, 2003 #2 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)
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)
J Juan M. Afan de Ribera Oct 27, 2003 #3 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
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