Re: New User - Time, and date Stamp

Get the Windows username as a function an set the value of the lastuser
field to it.:

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

write the Now() function to the lastupdated timestamp field. You may use the
BeforeUpdate event to write the values, something like (air code):

Sub Form_BeforeUpdate(Cancel As Integer)
Me.txtLastUser = fOSUserName()
Me.txtLastUpdated = Now()
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Kim" <Kim@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A6C48D26-8A14-4CD7-8B11-0D93E2DC605D@xxxxxxxxxxxxxxxx
I'm building a tracking database. How do I create a date and time stamp
for
each time some updates my form. I want to includ the name, time and date
they last updated the form. Is this possible? I've only been using this
for
about 2 weeks. Can someone help me please.


.

Loading