Environ function

[accessuser1308]

In previous versions of MS Access I was able to use the Environ (UserName)
function in the default value field of a text box to have it display the
users login name from Windows. I have put a database that I previously made
(Access 2003/WinXP Pro) onto a machine running Win Vista and Access 2007. I
get an error regarding the Environ function in the text box, and the username
will not display. I had to remove the function in order to use the form,
since the error would continually pop up if I moved to a new field on the
form. Does this function still exist in Access 2007 and/or is there a
modification to make it work with Win Vista?

Thank you

 

[Allen Browne]

It might depend on the user's permissions.

Here is an alternative (and more reliable) approach:
http://www.mvps.org/access/api/api0008.htm

It involves an API call to Windows, to ask what the user name is.

 

[boblarson]

I, personally, would go with the API that Allen suggests. However, just for
knowledge's sake, you can possibly still use the Environ but you need to use
Environ$ instead.
--
Bob Larson
Access World Forums Administrator

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[Eric]

Le 20/06/08 17:32, dans (e-mail address removed),