Date Modified for a Record

[Paul]

Hi
I am new to Access, is there any way to create a modify date field for a
record when the overall record is modified?

Paul

 

[golfinray]

If you are using a form, put a command button on the form to save the changes
on the form, then right click on the command button, go to properties,
events, go to the event ccreated by the command button and add the follwoing
line:
Me.Last_updated = Now()
Add a column to your table that has a date datatype and call it Last_updated.

 

[Paul]

I am using a form, but the users have access to the DB tables also. Is there
any way to do this at the DB level?

Paul

 

[Fred]

The short answer is no.

On multi-user application, 90% (developers say 100%) of the time it's best
to confine user input to forms. This is one example of a reason for that
90%/100%.

 

[Paul]

OK. Thanks.

Paul

 

[John W. Vinson]

I am using a form, but the users have access to the DB tables also. Is there
any way to do this at the DB level?

In SQL/Server with an update trigger, yes; in an Access database table,
unfortunately no.