modified date field
in [Tables]
|
From: ljg08 on 19 Jun 2008 15:45 Hi Guys, I have a table that has field [modified], which is a date field, can anyone tell me how I get this to update when details of the record are changed, are thier any default settings I can apply to this field to update when the records value is changed, other than an update query? TIA
From: KARL DEWEY on 19 Jun 2008 16:11 Not doing it in the table. Anyway you should use a form to add and edit records. You can have an Event on your form - 'On Change' or 'After Update' to Set Value using Now() to capture the modification DateTime. -- KARL DEWEY Build a little - Test a little "ljg08" wrote: > Hi Guys, > > I have a table that has field [modified], which is a date field, can anyone > tell me how I get this to update when details of the record are changed, are > thier any default settings I can apply to this field to update when the > records value is changed, other than an update query? > > TIA > > >
From: ljg08 on 20 Jun 2008 07:20 Cheers Karl, Thats the answer, many thanks "KARL DEWEY" <KARLDEWEY(a)discussions.microsoft.com> wrote in message news:7F7AF7FA-AA39-4C69-932F-A1AE290AA025(a)microsoft.com... > Not doing it in the table. Anyway you should use a form to add and edit > records. > You can have an Event on your form - 'On Change' or 'After Update' to Set > Value using Now() to capture the modification DateTime. > -- > KARL DEWEY > Build a little - Test a little > > > "ljg08" wrote: > >> Hi Guys, >> >> I have a table that has field [modified], which is a date field, can >> anyone >> tell me how I get this to update when details of the record are changed, >> are >> thier any default settings I can apply to this field to update when the >> records value is changed, other than an update query? >> >> TIA >> >> >>
|
Pages: 1 Prev: sequencial number not autonumber Next: add record to paytable |