Want to programmatically datestamp field in when table changes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Sorry for the dumb question -- it's been too long since I programmed in Access:

I want my Date field automatically datestamped when the Initials field is
not null.
I'm using only select or update queries to write to the table.

How to I access the on_exit event for a field in a table or a similar
terminal event?

Thanks in advance?

Philip
 
You'll need to include the "datestamp" field in your Update query and set it
to the value of =Date() or =Now(). There are no triggers in the Jet database
engine to automatically do this every time the Record is updated -- you can
include the date stamping in your Query, or include it in a Form if the Form
is always used to update. If your users open the Table in datasheet view,
Records that they update will not be datestamped.

Larry Linson
Microsoft Access MVP
 
Access does not support table level events, as the developer you'll have
to provide a middle layer to detect the change. If you were running
SQLServer, however, it would be possible to setup a trigger.
 
Back
Top