save the username and date

  • Thread starter Interactive worksheet
  • Start date
I

Interactive worksheet

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?
 
A

Arvin Meyer [MVP]

Interactive worksheet said:
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?
Click to expand...

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
 
Top