473,386 Members | 1,699 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Display Alerts - How Do you disable them in VBA?

I am running/coding update queries in MS Acess VBA 2002
and each update query asks the user to click "Yes or No" to verify they want to update the table.

I do not want this user interaction (since there are alot of queries)

How can I set the Display Alerts to FALSE (like in Excel) so that this box does not pop up asking the user if they want to update the table?

or is there a way for me to hard code a line to automatically click "Yes" for the end user when this verification box/display alert pops up?

I have searched for this answer and cannot find it. Thank in advance for ANY help. This project is due tomorrow Friday the 8th.

Willis
Feb 7 '08 #1
3 28880
DoCmd.SetWarnings False 'will turn off the popup warnings
DoCmd.SetWarnings True 'will turn them back on

Makes sure you turn them off when necessary as it will disable /all/ error and warning messages!
Feb 7 '08 #2
NeoPa
32,556 Expert Mod 16PB
Good answer, but you should understand that this is only for data type warning messages. This will not disable error messages as such.
Feb 7 '08 #3
Thanks for the quick reply, it really helped - Everything is working fine now.
I REALLY appreciate it. Thanks Willis
Feb 7 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

30
by: Blnukem | last post by:
Hi All I'm new to javascript and was wondering if someone can help me with this I want to disable my second and third drop-box if the first one is selected to "Closed" I think I'm close but just...
0
by: ryan baldwin | last post by:
Hi, I posted this in the GotDotNet .NET Alerts forum, but that was 3 days ago and still no reply so I'll try my luck here. My apologies if there's a better group to post this question in, but at...
1
by: rhompi | last post by:
Hi, I have a problem displaying korean characters in javascript alerts. Korean characters are displayed fine in menus, webpages, buttons,etc. except in javascript alerts. Can anyone please help...
2
by: Luis Esteban Valencia | last post by:
Is there a way to send timed alerts to ALL web clients conencted to the IIS server (on a server level)? IF NOT Is there a way to send timed alerts to ALL web clients using a certain .Net web...
4
by: nick | last post by:
Is it possible to disable/suppress alert popups in javascript? I need to write a function that will loop through a form's inputs and "manually" fire their onchange events (if found). Some of those...
7
by: swethasivaram | last post by:
Hello I have a Java-based web application whose interface can be in multiple languages. My requirement is that the javascript alerts that I display should be displayed in the language in which...
1
by: =?Utf-8?B?QmFkaXM=?= | last post by:
I'm using automation for mail merging but the process hangs because at some stage some alerts may come around! I have tried: wrdApp.DisplayAlerts = Word.WdAlertLevel.wdAlertsNone; &...
17
by: ineuw | last post by:
I must use alerts in French with accented characters and what I get is gibberish. How can I display alert messages properly, as HTML character codes for accented characters don't work in...
0
by: jason.richard | last post by:
Hi Does anyone know how to disable and enable ConfirmButtonExtender, using Javascript? I don't want the ConfirmButtonExtender to be enable until a change to a text box has been made. Here...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.