Access Make table quiries problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

Can someone tell me how to suppress the pop up (yes/no) messages that appear
if you run a make table query?

Jai
 
You can turn off SetWarnings.

However, that will also prevent you being notified if the query does not
complete as expected.

A better solution would be to use the Execute method. This example assumes
the string strSql contains your query statement. It gives on confirmation
message, but does notify you if there is an error:
dbEngine(0)(0).Execute strSql, dbFailOnError
 
Back
Top