Access Make table quiries problem

J

Jai_Friday

Hello,

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

Jai
 
A

Allen Browne

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
 
J

Jai_Friday

Thanks

I will give that a go , when it comes down the coding I'm a bit rusty

Jai
 
Top