Time Stamps

[gheyman]

I remember reading that Access can add the user and time updated fields. I cannot remember that technical name to go back and do some more reading on it.

Does someone know what this is called?

 

[Joe4]

Google searches are great for finding this kind of stuff (just describe it to the best of your ability and see what pops up).

Might want to start here: https://support.office.com/en-us/ar...modified-0c46efc5-5b43-4751-b3a8-c246505af66d

 

[ParamRay]

For the date/time, put a default value on the field using the expression: =Now()

For the username, probably use a AfterInsert event handler on the form and incorporate the VBA function: =Environ("Username")