save the username and date

[Guest]

Hello,

I was wondering if anyone knows how to call the system to save the date and
username into a table of the last person who was in a particular access table?

 

[Arvin Meyer [MVP]]

Hello,

I was wondering if anyone knows how to call the system to save the date
and
username into a table of the last person who was in a particular access
table?

You can get the username by putting code in a standard module:

http://www.mvps.org/access/api/api0008.htm

The system date can be called using:

Date()

and the date and time by using:

Now()

If you have fields in the table with textboxes on the form(txtUpdated and
txtUser)

Sub Form_BeforeUpdate(Cancel As Integer)
Me.txtUpdated = Now()
Me.txtUser = fOSUserName()
End Sub