|
| 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
March 24th, 2005, 05:17 PM
|
|||
|
|||
suppressing alert messages
Hi,
I set a string variable equal to my "insert" query and run it with: DoCmd.runSQL myStr Everything works fine but there's alway an alert message that pops up telling me that i'm adding a record. Is there anyway to suppress it? I know in Excel it would be something like: Application.DisplayAlerts = False Thanks for the help! T 
|
|
#2
March 25th, 2005, 08:40 AM
|
|||
|
|||
|
T,
DoCmd.SetWarnings False You should put a DoCmd.SetWarnings True line afterwards. -- Steve Schapel, Microsoft Access MVP tvt wrote: Hi, I set a string variable equal to my "insert" query and run it with: DoCmd.runSQL myStr Everything works fine but there's alway an alert message that pops up telling me that i'm adding a record. Is there anyway to suppress it? I know in Excel it would be something like: Application.DisplayAlerts = False Thanks for the help! T
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Problem Updating New Messages from NTTP News Server OE | Chad Harris | Outlook Express | 19 | February 7th, 2005 07:21 PM |
| How do I get and audible alert for incoming messages | basenji | General Discussions | 1 | August 29th, 2004 05:01 PM |
| Missing messages inbox | Outlook Express | 3 | August 17th, 2004 08:12 PM | |
| Problem with OE .dbx files | Aidan HUghes | Outlook Express | 1 | August 10th, 2004 06:19 PM |
| Auto Update Problem - OE Now Not Deleting Some Messages | Kirk Kridner | Outlook Express | 0 | July 16th, 2004 09:31 PM |
Linear Mode
