473,396 Members | 2,140 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,396 software developers and data experts.

running a SQL Update without confirmation prompt from Access

using Access 2007. I would like to call a sql update query with a macro, but I want it to update without prompting or otherwise notifying the user. Anyone got any ideas on this?
Jul 26 '07 #1
4 9444
Rabbit
12,516 Expert Mod 8TB
In VBA code you use
DoCmd.SetWarnings False
SQL Stuff Here
DoCmd.SetWarnings True

I assume there's a similar thing for macros.
Jul 26 '07 #2
In VBA code you use
DoCmd.SetWarnings False
SQL Stuff Here
DoCmd.SetWarnings True

I assume there's a similar thing for macros.
huh, that's what the does....can't wait to try it!
Jul 26 '07 #3
That did it.....I'm using it to solve a record lock issue by updating a field each time a record is opened. very clean, simple fix.

Thanks.
Jul 26 '07 #4
Rabbit
12,516 Expert Mod 8TB
Not a problem. Good luck.
Jul 26 '07 #5

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

Similar topics

7
by: David Walker | last post by:
I've got a server where register_globals is on in php.ini, but its affecting the way the website works. It was programmed with the assumption that it would always be off, and i've always used the...
0
by: Mohammad Khan | last post by:
------=_NextPart_000_005F_01C35137.8729F1B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is there any way to restrict UPDATE without a WHERE...
28
by: PerryC | last post by:
Anyone know how to auto close the parent / opener window without confirmation? I have tried: <script> opener.window.close() </script> ----I put it in the child html page, and nothing...
0
by: Johan Ĺhlén | last post by:
Hi, Using a treeview with viewstate enabled easily generates very big viewstates (hundreds of Ks). Does anyone have any experience of running treeviews without viewstate? To keep track of...
6
by: mg | last post by:
The following .exe and its parameters work correctly from the command prompt (it prints x.pdf without prompting the user. acrord32.exe /t "c:\exportfiles\x.pdf" "HP LaserJet 3300 Series PCL 6"...
2
by: Jim S | last post by:
To my surprise and chagrin, newer versions of Access have disabled the functionality that lets users change the data in linked tables that point to a range in an Excel workbook. This is "because of...
2
by: solargovind | last post by:
Hi, Can anybody suggest me how to take data from an Excel file without import into Access as a Table..? Bcoz...I hve several file. if i import, it would take more time and increase the file...
2
samycbe
by: samycbe | last post by:
Hi, I want to open a file from javascript with the code, window.open("file://///xxxxxxxx/xxxx/xx/freedom.exe"). It is opening preperly. But asking the prompt for open,save and cancel. I want to...
3
by: razjafry | last post by:
Hi, I am using Access2000/2002. When we make any change in the tables most of the time it goes in effect without any confirmation which is not good as someone can by mistake make changes which get...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
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
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
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
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,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

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.