R Reb74 May 14, 2008 #1 Does Microsoft have a list of active variables for VBA in Access 2007? Seems like the ENVIRON variable no longer works. Thanks
Does Microsoft have a list of active variables for VBA in Access 2007? Seems like the ENVIRON variable no longer works. Thanks
A Alex Dybenko May 14, 2008 #2 Hi, not sure you can do so, and ENVIRON gets system variables, like you do in command prompt with SET -- Best regards, ___________ Alex Dybenko (MVP) http://accessblog.net http://www.PointLtd.com
Hi, not sure you can do so, and ENVIRON gets system variables, like you do in command prompt with SET -- Best regards, ___________ Alex Dybenko (MVP) http://accessblog.net http://www.PointLtd.com
K Klatuu May 14, 2008 #3 As you are experiencing, using ENVIRON in any version of Access is unreliable. For most environment variables, there is another way to get the information. Which are you trying to retrieve?
As you are experiencing, using ENVIRON in any version of Access is unreliable. For most environment variables, there is another way to get the information. Which are you trying to retrieve?