Error 3085 Undefined function ‘Environ’ in expression

Topic

New Reply

Hi,

We currently have an Access 2000 front end and wanting to go to Access 2013.

When loading our form in a query there above error message appears.

Any ideas why?

Reply | Quote

Replies

Luke,

I’m just guessing here since I don’t have Access 2000 to check.
Environ is a built-in function, in Access 2003 and newer, that returns the value of an Environment Variable.
Ex:
?Environ(“UserName”)
Bruce

If as the message suggests someone built a User-Defined Function in Access 2000 because that version did NOT contain the built-in version it could be causing a conflict in the new version that does have the built-in version. You’ll need to check the code for the database in the VBE (Visual Basic Environment) {Alt+F11}.
Once there do a search for Environ. HTH :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

It returns the value in VBA, but in the query it causes the issue

Reply | Quote

Luke,

Could you post a screen shot of the query design window making sure the column with the offending statement is wide enough to show everything in it? :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Luke,

Environ is not available in the Query Expression builder!
You can get around this by building your own UDF (User Defined Function)

Code:

Function zMyEnvVar(zEnvName As String) As String

    zMyEnvVar = Environ(zEnvName)
    
End Function  'zMyEnvVar

Just place the above code in a standard module then call it from your query like this:
[noparse]Userid: zMyEnvVar(“UserName”)[/noparse]
It works just fine:
36555-UDFEnviron
HTH :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Okay, will give a try, thank you

Reply | Quote