Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Tracking update to Table

Status
Not open for further replies.

osimini1

MIS
Jun 9, 2008
29
US
How do I default userid or systemid to track who made changes to table or which employee data entered particular record or records. I am lost on how to do it, please

 
Set the default value of the field or hidden text box to something that returns the username.

For example, environ ("username"), returns the windows environment variable username. Assuming you are using an Active Directory domain and Windows 2000 and later systems, that should work fine.

If you implemented access security, you could use currentuser().

The default property you specify would look something like...

Code:
=environ ("username")
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top