Unknown function 'Eviron" ?

[Rusty Shackelford]

I put =Environ("username") to put the logged in user into a field. This
works on all the other machines but not on one. The one machine spits back a
Unknown function "environ" in validation or default value on (table). I have
tried to reinstall office and it still happens. Any ideas what to look for
next?

 

[Dirk Goldgar]

I put =Environ("username") to put the logged in user into a field.
This works on all the other machines but not on one. The one machine
spits back a Unknown function "environ" in validation or default
value on (table). I have tried to reinstall office and it still
happens. Any ideas what to look for next?

I'm not sure if it applies in a controlsource, but several recent
questions about "unknown functions" have been due to the operation of
Jet Sandbox Mode. See if this KB article has any bearing on your
problem:

http://support.microsoft.com/default.aspx?scid=kb;en-us;294698

If it's not that, it may just be a broken reference. Follow up by
checking this as directed by Doug Steele here:


http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

 

[Tony Toews]

I put =Environ("username") to put the logged in user into a field. This
works on all the other machines but not on one. The one machine spits back a
Unknown function "environ" in validation or default value on (table). I have
tried to reinstall office and it still happens. Any ideas what to look for
next?

To add to Dirk's posting don't even think of using environment
variables. They can be changed by the user using a command prompt.
Instead use the API call.

API: Get Login name
http://www.mvps.org/access/api/api0008.htm

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm