Default Value Function for Modify_Date Field

  • Thread starter Thread starter DKMonroe
  • Start date Start date
D

DKMonroe

I'm trying to create, at the table level, a field called modify_date,
which will change when ever something in that row is modified. I've
figured out how to create a create_date by entering Now() as the
default value. Is there a way to create a default value in the
modify_date field that will perform the same funtion? If so, what is
it? I'm VERY new to Access (2 weeks), but learn quickly.

Thanks in advance,
DKM
 
The only way to add Modify_Date capability is to do all your updates through
a form, and put logic in the form's BeforeUpdate event to populate the
field.
 
If you are trying to do this in an Access table, please let folks here know
when you succeed! Access tables don't have 'triggers', so it will be quite
difficult for Access to "know" that something's been changed in the table.

On the other hand, Access forms have a very rich event environment, and it
is very straight-forward to note when something's been changed when you're
looking at data via a form.

My suggestion -- use the forms, Luke!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
If you are trying to do this in an Access table, please let folks here know
when you succeed!  Access tables don't have 'triggers', so it will be quite
difficult for Access to "know" that something's been changed in the table..

On the other hand, Access forms have a very rich event environment, and it
is very straight-forward to note when something's been changed when you're
looking at data via a form.

My suggestion -- use the forms, Luke!

Regards

Jeff Boyce
Microsoft Office/Access MVP







- Show quoted text -
Click to expand...

lol...ok, I'll stick to the forms. I have a macro for that, but I
wasn't sure if that was the right thing to do.

Much appreciated everyone.
 
Back
Top