View Single Post
  #3 (permalink)  
Old October 17th, 2005, 11:12 AM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Yeah, it's a good idea to use environment variables to capture the identity of people making changes. I use these default values in tables where users will be creating new records, then I just don't show the fields and they are updated with the default values.

sUser = Environ("UserName")
sComp = Environ("ComputerName")
dTime = Now()

HTH



mmcdonal