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
|
|||
|
|||
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
|
|||
|
|||
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 |