Add a field that records date/time to when a record was last chang

B

bassplayer13

Hello all,

I know that you can add a property to a form that holds the date & time the
record was last updated, but I was wondering if you could add a field to a
table thet even if you go into the table itself and enter the data, it would
still update that field??

Thanks,
Mike
 
L

liuwen

bassplayer13 said:
Hello all,

I know that you can add a property to a form that holds the date & time the
record was last updated, but I was wondering if you could add a field to a
table thet even if you go into the table itself and enter the data, it would
still update that field??

Thanks,
Mike
Click to expand...


erwe
 
R

Rick Brandt

Nope. Not unless the tables a link to a server database that supports triggers
like SQL Server. Access/Jet tables have no events like that.
 
W

Wizardry

Actually you do have the capabillites of doing making your own
triggers/events, If you open your form in design view then right click on the
form, scroll down to properties. Once, that pops up, ensure that you have (
FORM ) or (subform name)in the drop down box, so that you cover that forms
properties. You will have a tabs at the top, click on the on that says (ALL),
scroll down untill you see ( ON OPEN ) select that, and choose (event
procedure). Now the final step requires knowledge of VB, click the button to
the right that looks like( ...) that will open the VB editor, and write a
Function to suit your needs.
 
Top