Auto Tracking of Operator Id
Auto Tracking of Operator Id
(OP)
Wishful thinking, but is there a way to have the operator id in a table set to the operator who created the record (their signon id) e.g. using the default property, etc.
I know how to do this in a form but there are quite a few forms that would require changing as well as updating the changed forms on many computers.
Thanks Alex
I know how to do this in a form but there are quite a few forms that would require changing as well as updating the changed forms on many computers.
Thanks Alex
RE: Auto Tracking of Operator Id
so build a function
public function getPK() as string
'some function here to determine the user name
'determine the last id in table
'create a new key
end function
in the table default value
=getPK()
However if you are currently using an AutoID you can simply add another field for UserCreated in the table. Set the default for that field to a function that returns the user. There really is not a good reason to make the PK contain the user id. Just let the PK be unique and have another field for user. You can always concatenate this info for visibility.
RE: Auto Tracking of Operator Id
http://blo
Anyone using these in 2010 have info/opinions?
RE: Auto Tracking of Operator Id
Regards Alex
RE: Auto Tracking of Operator Id
I think I gave you bad information. I do not have Access on this computer to double check. However, I know you can use a vba function as a default table value. Example in a date field you can create a time stamp
= now()
However, you might not be able to use a User Defined Function (UDF). You will then have to use vba functions for the default value. You may want to test
=Environ("username")
and see if the passes the user name.