environment variables in 2007

[rgtravel]

Just updated to Access 2007 from 2003 and my app does not pull in any environment variables. =environ("variablename")

Anyone else have this problem?

 

[boblarson]

Try using =Environ$("variablename")

 

[rgtravel]

no - same thing. Wondering if there's a setting in 2007 that is not allowing Access to look at system variables?

 

[freakazeud]

re:

Hi,
Environ variables are actually very unreliable and can be easily be reset by the user. I hardly ever use them. API calls are much more reliable and perform almost all the same work. BTW...I did test some Environ functions in Acc2007 on WinXP and they work fine on my system. Make sure there are still set correctly under Control Panel--System--Advanced--Environment Variables...Also make sure they work in the immediate window of the VBA editor e.g. ?Environ("USERNAME")
HTH
Good luck

 

[boblarson]

Oli - what got me one time was seeing an API that someone actually posted to replace the use of Environ, but the API code they posted actually used the Environ call in it isn't that a hoot?

 

[freakazeud]

re:

That's what I call an oxymoron