Update a field with time stamp when other field are updated 
Author Message
 Update a field with time stamp when other field are updated
I Have a situaton where I have to update a field  called
(fld_UploadDateTime) when other fields are updated. I am using SQL
server as a backend and Access 97 as a frontend. Can someone help me
with this. Thanks


Wed, 01 Dec 2004 22:52:50 GMT
 Update a field with time stamp when other field are updated


Quote:
> I Have a situaton where I have to update a field  called
> (fld_UploadDateTime) when other fields are updated. I am using SQL
> server as a backend and Access 97 as a frontend. Can someone help me
> with this. Thanks

You want to look up triggers, specifically ON UPDATE.

Keep in mind a trigger is fired for the UPDATE set, not for individual rows.

So if your update affects more than 1 row, you have to be prepared to handle
that.



Thu, 02 Dec 2004 02:18:58 GMT
 Update a field with time stamp when other field are updated
Why not just set the date/time stamp field by placing the value from the
function Date() in the 'On Change' event in your Access form???

Regards,

Brad Feaker

Web Developer/Database Engineer
Morgan Keegan & Company

Quote:

> I Have a situaton where I have to update a field  called
> (fld_UploadDateTime) when other fields are updated. I am using SQL
> server as a backend and Access 97 as a frontend. Can someone help me
> with this. Thanks



Mon, 06 Dec 2004 15:48:34 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Using a trigger to update a time field in a table when a row is updated

2. Getting AM/PM Time formatting in a field with two Times

3. Time stamp on a table and updating with a trigger

4. update statistics time stamp ?

5. [Fwd: Time stamping updates/inserts on records]

6. Time stamping updates/inserts on records

7. time stamp field in one of the sql server

8. Time stamping memo fields

9. Notes field and date/time stamped entry

10. Time/Date stamping for repeating fields

11. SQL 101 Question: How do you use the update command to update a date field

12. trigger to update a field as the record is updated


 
Powered by phpBB® Forum Software