How to automatically enter UserName fields in tables

[Guest]

Hi,

I have several tables in an Access 2003 database.

On each one I have 4 columns - 2 for 'created by' user and date and two for
'amended by' user and date.

How do I populate these columns on Add new or Update row with the NT ID?

thanks for any help.

Philip

 

[Allen Browne]

Here is the code to get the user name:
http://www.mvps.org/access/api/api0008.htm

Use the BeforeUpdate event procedure of your form to assign these values.

 

[Guest]

Thankyou - I think that's what I need!

Philip

Here is the code to get the user name:
http://www.mvps.org/access/api/api0008.htm

Use the BeforeUpdate event procedure of your form to assign these values.