Suppress Warning Message - DAO Insert

[dave h]

Hi,

When using -

DoCmd.RunSQL mySQL with an INSERT INTO............

How can I surpress the dialog box that asks to confirm the append?

Thanks, Dave H.

 

[Brendan Reynolds]

Use "CurentDb.Execute mySQL" instead.

 

[Bob Bonta]

docmd.setwarnings false
docmd.runsql mysql
docmd.setwarnings true

 

[dave h]

Works like a charm - thanks much!

Use "CurentDb.Execute mySQL" instead.

 

[Mark via AccessMonster.com]

It's probably a good idea to include dbFailOnError at the end of the
..Execute statement:

CurentDb.Execute mySQL, dbFailOnError

Since using .Execute will not break on a failure during the operation,
you'll never know if something went wrong.

 

[Roger Carlson]

While bracketing the command with DoCmd.SetWarning will work, I always use
the .Execute method because it is demonstratably faster than DoCmd.RunSQL.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L