|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 31st, 2005, 09:59 PM
|
|||
|
|||
Suppress Warning Message - DAO Insert
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. 
|
|
#2
January 31st, 2005, 10:09 PM
|
|||
|
|||
|
Use "CurentDb.Execute mySQL" instead.
-- Brendan Reynolds (MVP) "dave h" wrote in message ... 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.
|
|
#3
January 31st, 2005, 10:12 PM
|
|||
|
|||
|
docmd.setwarnings false
docmd.runsql mysql docmd.setwarnings true -----Original Message----- 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. .
|
|
#4
January 31st, 2005, 10:15 PM
|
|||
|
|||
|
Works like a charm - thanks much!
"Brendan Reynolds" brenreyn at indigo dot ie wrote in message ... Use "CurentDb.Execute mySQL" instead. -- Brendan Reynolds (MVP) "dave h" wrote in message ... 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.
|
|
#5
February 1st, 2005, 02:34 PM
|
|||
|
|||
|
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. -- Message posted via http://www.accessmonster.com
|
|
#6
February 1st, 2005, 03:17 PM
|
|||
|
|||
|
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/...UBED1=ACCESS-L "Bob Bonta" wrote in message ... docmd.setwarnings false docmd.runsql mysql docmd.setwarnings true -----Original Message----- 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. .
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Challenging Charting | C TO | Charts and Charting | 0 | January 17th, 2005 06:57 PM |
| Warning message | Scott | Running & Setting Up Queries | 2 | October 6th, 2004 01:23 PM |
| how to suppress the security warning in Access 2003 | Paul | Using Forms | 1 | September 29th, 2004 09:53 PM |
Linear Mode
