Recording the date a particular field is modified. 
Author Message
 Recording the date a particular field is modified.
I'm trying to set up a relationship whereby when a person enters data into a
particular field in my database the date they did this is recorded in another
field.  I can't figure out how to set this up.

Any ideas are greatly appreciated!

Abe



Wed, 07 Mar 2001 03:00:00 GMT
 Recording the date a particular field is modified.

One way is to put a invisible button over the field and have it run a script
that puts the current date in another field. Then have the script leave the
cusor in the origional field for adding data. This would change the
modification date anytime someone entered the field whether they made
changes or not.

Quote:

>I'm trying to set up a relationship whereby when a person enters data into
a
>particular field in my database the date they did this is recorded in
another
>field.  I can't figure out how to set this up.

>Any ideas are greatly appreciated!

>Abe



Wed, 07 Mar 2001 03:00:00 GMT
 Recording the date a particular field is modified.

Quote:

> I'm trying to set up a relationship whereby when a person enters data into a
> particular field in my database the date they did this is recorded in another
> field.  I can't figure out how to set this up.

> Any ideas are greatly appreciated!

You can use the concept of a "post" button next to the field being
modified. If you make your users click that, then it can insert the
current date into the second field and NOT be updated as the Modified
Date function does with any contact on that first field.

Depends on what you want...something that will change if anybody even
CLICKS into the first field, or a more permanent record.

Lynn Allen
Allen & Allen Semiotics         FSA Member - Filemaker Pro Consulting
http://www.semiotics.com        Web & Graphic Design



Wed, 07 Mar 2001 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Date field for modified record

2. Getting records for a particular Date

3. Newbie -- Retrieving particular record field question.

4. automatically find all records that have any entry in a particular field

5. Select not returning records based on Date I am using

6. Updating Date when the record is modified

7. Date stamping modified records

8. Date stamping modified records

9. Last Modified Date Field

10. Date modified as repeating field?

11. Modify table field properties and record values in Access macro

12. Create Date and Modify Date


 
Powered by phpBB® Forum Software