Hi @Seth and @Rabbit, thanks for the replies. How can I implement Rabbit's suggestion of storing the values and then comparing old and current values?
Thanks again. I'm really learning a lot here.
ephi
Last Activity: Feb 13 '13, 01:04 PM
Joined: Feb 28 '12
Location:
-
Run query only if values of either of 2 fields have been updated/changed
I have an append query which is tied to the OnClick event of a button on my form. I want the query to run only if the values of either of 2 fields is updated on the form; the 'Location' field or the 'Assigned To' field.
i.e. if the value of the 'Location' field is changed, or if the value of the 'AssignedTo' field is changed, then the query should run.
The query should also run if both fields have been updated.
... -
Thank you Seth. The WHERE clause fixed the problem.
I will post the second part of the question ion another thread.
Thanks so much for your assistance.Leave a comment:
-
Hello Seth, here is my query code:
ThanksCode:INSERT INTO AssetMovement ( ID, Location, Condition, AssignedTo, AssetTag ) SELECT Assets.ID, Assets.Location, Assets.Condition, Assets.AssignedTo, Assets.AssetTag FROM Assets;
Leave a comment:
-
Run a query to append only the current record to another table
I have 2 tables in my database (Assets and AssetMovements) .
What I'm trying to achieve is that when the value of the 'Location' field is modified in a record in the 'Assets' table, once the user clicks the save button the record should be saved normally and a copy should be appended to the 'AssetMovements ' table.
The problem is that my current query appends all the records in the 'Assets' table to the 'AssetMovements ' table.... -
Hi,Seth and zmbd. It worked. The query ran but it appended all the records to the other table, instead of just the current record.
What should I do?
Thanks.Leave a comment:
-
Hi Seth, thanks again. I tried it but the SetWarnings options didn't appear. Let me explain my entire problem here, in the hope that you might advise me on a better way to go about the whole thing:
I started out with a single table and a form for adding assets. Every time an asset is issued to an employee, the original asset field is modified and the record is saved.
Now I want to track asset movements. I want to be able to run...Leave a comment:
-
Thanks for your response Seth. I am using Access 2010 and when I go to the Save button's OnClick event, it only allows me build macros, so I can't find anywhere to paste the code. How do I get around this?Leave a comment:
-
ephi started a topic Append record to another table every time a record is added/updated on parent tablein AccessAppend record to another table every time a record is added/updated on parent table
I have a basic asset management database with 2 tables (Assets and AssetMovements) . I want a new record to be created in the AssetMovements table every time a new asset is added to the Assets table or an existing asset record is modified.
The AssetMovements table is just there to record the transactions.
I have created an append query but how can I set it up so that whenever the 'Save' button on the Assets form is clicked, it runs the... -
IIS metabase problem
Hi,
I activated IIS on my XP machine and then installed an Intranet app (.NET).
When I tried to access the portal, I got an error with the message "Failed to access IIS metabase".
The exact message is below. Any help would be appreciated.
Server Error in '/portal' Application.
--------------------------------------------------------------------------------
Failed to access...
No activity results to display
Leave a comment: