Hi folks;
Here's a mystery for you. I've written an update query that runs every time my database opens and does a little housekeeping amongst the records. It updates a yes/no value in one table to True if a text value in another table ="Client". Anyway, I run the query and it gives the usual "You are about to update 83 records blah blah.... Yes or No?" But if I click Yes, nothing happens! The 83 records stay un-updated! Anyone know what's happening here? Also, I'd like this query to run in the background on startup, is there any way of suppressing the warning messages?
Thanks guys!
8 1605
Hi folks;
Here's a mystery for you. I've written an update query that runs every time my database opens and does a little housekeeping amongst the records. It updates a yes/no value in one table to True if a text value in another table ="Client". Anyway, I run the query and it gives the usual "You are about to update 83 records blah blah.... Yes or No?" But if I click Yes, nothing happens! The 83 records stay un-updated! Anyone know what's happening here? Also, I'd like this query to run in the background on startup, is there any way of suppressing the warning messages?
Thanks guys!
To stop the message confirming the query, go to the command menu and select tools>options>e dit/find tab>uncheck confirm action queries.
Regarding the query, you should be using an append (not update) query if you are adding new records. When (what event procedure) are you running the query? If still a problem, please post the Sql view of your query.
Can you post the SQL view of your Query ?
Here it is:
UPDATE tblInstDetails INNER JOIN tblSupplierDeta ils ON tblInstDetails. UniID = tblSupplierDeta ils.UniID SET tblInstDetails. MerchExistingCl ient = Yes
WHERE ((([tblSupplierDeta ils]![MerchandiseCurr entSupplier])="Success")) ;
Don't know if that's any help, might as well be Greek to me!
Here it is:
UPDATE tblInstDetails INNER JOIN tblSupplierDeta ils ON tblInstDetails. UniID = tblSupplierDeta ils.UniID SET tblInstDetails. MerchExistingCl ient = Yes
WHERE ((([tblSupplierDeta ils]![MerchandiseCurr entSupplier])="Success")) ;
Don't know if that's any help, might as well be Greek to me!
Try this:
UPDATE tblInstDetails INNER JOIN tblSupplierDeta ils ON tblInstDetails. UniID = tblSupplierDeta ils.UniID SET tblInstDetails. MerchExistingCl ient = True WHERE ((([tblSupplierDeta ils]![MerchandiseCurr entSupplier])='Success'));
-----------------------------------------------
Also, were you able to change the setup to uncheck "confirm action queries" like I previously discussed and is that working for you?
Let me know.
Nah, it's still not working! I'm sure the syntax of the query is correct but for some reason the database is springing back to its old shape as soon as it's applied. I just don't understand it! The DB is stored on a shared network drive but I don't see how that can be affecing things - it's not set to read-ony or anything. I'll have a crack at setting that option to suppress the confirmation box when (or if!) I get this query working!
Cheers!
Nah, it's still not working! I'm sure the syntax of the query is correct but for some reason the database is springing back to its old shape as soon as it's applied. I just don't understand it! The DB is stored on a shared network drive but I don't see how that can be affecing things - it's not set to read-ony or anything. I'll have a crack at setting that option to suppress the confirmation box when (or if!) I get this query working!
Cheers!
Your syntax is correct, but the query is not finding any data that meets the query criteria. Convert your query back to a select query and see if you get any output from it. If not, recheck your criteria against your data.
Hmm... I think it's actually worked but the problem is that although Access is still saying "You are about to update 90 rows...." I think what it actually means is that "Your query has found 90 rows that fall under its jurisdiction... ", even though it's already updated them. Odd...
Hmm... I think it's actually worked but the problem is that although Access is still saying "You are about to update 90 rows...." I think what it actually means is that "Your query has found 90 rows that fall under its jurisdiction... ", even though it's already updated them. Odd...
No, it is about to update 90 records and is confirming that you want to go forward. You won't get that message if you uncheck the box for confirmation of action queries that I mentioned to you previously.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Surendra |
last post by:
I have this query that I need to use in an Update statement to
populate a field in the table by the value of Sq
----------------------------------------------------------------------------
Inline View Query:
Select Sq
from
(
Select substr(to_date(End_Date,"DD-MON-YYYY"),4), End_Date,
Rank() Over (Partition by substr(to_date(End_Date,"DD-MON-YYYY"),4)
Order by End_Date) As Sq
|
by: Falco Vermeer |
last post by:
Hi,
I tried to use the following query to update a value in one table with
a value from another table:
UPDATE tbl1
SET col1 = tbl2.col2
FROM tbl1, tbl2
WHERE tbl1. = tbl2.
|
by: Mike Leahy |
last post by:
Hello all,
This question is related to updating tables - is there any way to calculate or
update the values in a column in a table to the values in a field produced by
a query result? An example of what I'm trying to do is below:
update (tbl_ind_mananas LEFT JOIN (select count(*) as count, (dubicacion ||
zona || manzana) as cod_manzana from tbl_censo_poblacion_1993 group by
dubicacion, zona, manzana) tbl1 on relacion = cod_manzana) as...
|
by: Jeff Wilson |
last post by:
Seeing an odd situation I've not seen before.
Have VB that updates a field in a table based on a form value when a
button is clicked. Directly after the .Update, I call another
function that does some other work and, in the process, queries the
table I just updated for the record I just updated and it does not see
the update I just made.
If I run in the debugger the problem doesn't occur. It seems like the
..Update event is not yet...
|
by: Maxi |
last post by:
There is a lotto system which picks 21 numbers every day out of 80
numbers.
I have a table (name:Lotto) with 22 fields (name:Date,P1,P2....P21)
Here is the structure and sample data:
"Date","P1","P2","P3","P4","P5","P6","P7","P8","P9","P10","P11","P12","P13","P14","P15","P16","P17","P18","P19","P20","P21"
1/1/2005,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21
1/2/2005,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22
| |
by: Mark Carlyle via AccessMonster.com |
last post by:
I have this update query that I am trying to run. I know the syntax is
messed up but do not know how to correct it.
Select 'UPDATE', Transactions,'Set = where =
' From "Get Daily Balances"
Transactions = name of the table I want to update
balance = name of the field i want to update
daily balance= name of the query result that I want to move to the table
|
by: Andy_Khosravi |
last post by:
I'm trying to build a search utility for users to find 'inquiries' in
my database that involves several tables. This is normally easy to do
with the query builder, but I have a unique situation involving a multi
select listbox. Unfortunatly, my SQL skills are somewhat limited, so
I'm not sure if there is an easy way around it. To simplify the
explanation, I'll simplify the table/field setup to get at the meat of
the question.
I have a...
|
by: emily.a.day |
last post by:
I have a book database, and I have set up a query to search by
subject. As it is now, the searcher has to know the subject and type
it into the query. I wonder if there is a way to have a combo box
where the searcher can select the subject before running the query,
rather than consulting the separate subject list and typing the
subject in manually.
I have tried sticking the combo box in the report, but can't figure
that out. I think...
|
by: ARC |
last post by:
Hello all,
So I'm knee deep in this import utility program, and am coming up with all
sorts of "gotcha's!".
1st off. On a "Find Duplicates Query", does anyone have a good solution for
renaming the duplicate records? My thinking was to take the results of the
duplicate query, and somehow have it number each line where there is a
duplicate (tried a groups query, but "count" won't work), then do an update
query to change the duplicate to...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |