MS Access 2003 - Record Current User in a table

Dear Experts,

I have been using the following as the default value in a table field:

=Environ$("UserName")

Its purpose is to record the current username in the table. It has been working but now it is not. The error is 'unknown function in validation expression.
 Does anyone know what is going wrong?
kevin1478Asked:
Who is Participating?
 
peter57rConnect With a Mentor Commented:
Just re-reading this, I'm not sure this solution will work for a Default value, as you can't use a user defined function as a default value for a table field.
You will probably have to move your default entry to your data entry form.

 
0
 
peter57rCommented:
If you install A2003in the recommended way, this is the normal situation.
Environ() is regarded as one of the 'Unsafe Expressions '  which is now barred from use in property settings.

See here:
http://office.microsoft.com/en-us/access/HA011225981033.aspx#050

look at the 5th Q for specific reference to Environ
0
 
kevin1478Author Commented:
Thank you.
0
All Courses

From novice to tech pro — start learning today.