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
|
|||
|
|||
How to run a query if record has been edited
I have access 2000, how do I run a query from my form only when a record has
been changed, edited etc. Example: I go to a record from my form, lets say a week later. I make a change to the record. What I need is to run an append query only when a change is made. How can i do this. Thanks...Randy |
#2
|
|||
|
|||
How to run a query if record has been edited
Use the before update evnet and/or test for the form being dirty (changed).
Look in the help files for me.dirty Rick B "Randy" wrote in message ... I have access 2000, how do I run a query from my form only when a record has been changed, edited etc. Example: I go to a record from my form, lets say a week later. I make a change to the record. What I need is to run an append query only when a change is made. How can i do this. Thanks...Randy |
#3
|
|||
|
|||
How to run a query if record has been edited
Hi Randy,
The implication of your question is that you want to have two versions of your record. The first version is as it was last saved and the new version is the one as you just changed. If you really just want to change the record, just make your changes and move on. The record will be saved as you have just edited it. HTH -- -Larry- -- "Randy" wrote in message ... I have access 2000, how do I run a query from my form only when a record has been changed, edited etc. Example: I go to a record from my form, lets say a week later. I make a change to the record. What I need is to run an append query only when a change is made. How can i do this. Thanks...Randy |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Update another table with a Max record query | Ngan | Running & Setting Up Queries | 2 | June 22nd, 2004 05:01 PM |
trying to query an open/current record in order to email that reco | JulieC | Running & Setting Up Queries | 1 | June 9th, 2004 06:17 PM |
trying to query current record on form in order to email that reco | JulieC | Running & Setting Up Queries | 0 | June 9th, 2004 05:38 PM |
Update query based on value in a different record of the same table | Dale Peart | Running & Setting Up Queries | 2 | June 9th, 2004 12:53 AM |
query to select one record using report name | Nasos | Running & Setting Up Queries | 5 | June 3rd, 2004 01:20 PM |