Error message "Undefined function ..."

[Gabriel Maraqa]

To whom it may concern:

Hi!

I have an application running on Access 2002 that causes
an error when opening a very specific form. It
says: "Undefined function 'Environ' in expression". I have
already checked the links and references to other files or
libraries. There are no references marked as "Missing:"
The application has been migrated from Access 97. Could
there be some incompatible libraries? What else can be the
problem?

Thank you very much for your feedback.

Kind regards
Gabriel

 

[Wayne Morgan]

Try creating a new database file and use Environ in it. If it works, compare
the References between the two files to see if you have an outdated
reference selected. For more information on reference errors, follow this
link.

http://members.iinet.net.au/~allenbrowne/ser-38.html

 

[Douglas J. Steele]

Even though no references are marked as Missing, it could still be a
References problem.

Select an additional reference at random, back out of the dialog, then go
back in and unselect the reference you just added. If that doesn't solve the
problem, try to unselect as many of the selected references as you can
(Access may not let you unselect them all), back out of the dialog, then go
back in and reselect the references you just unselected. (NOTE: write down
what the references are before you delete them, because they'll be in a
different order when you go back in!)

 

[Dirk Goldgar]

To whom it may concern:

Hi!

I have an application running on Access 2002 that causes
an error when opening a very specific form. It
says: "Undefined function 'Environ' in expression". I have
already checked the links and references to other files or
libraries. There are no references marked as "Missing:"
The application has been migrated from Access 97. Could
there be some incompatible libraries? What else can be the
problem?

Thank you very much for your feedback.

Kind regards
Gabriel

In addition to the possible References issue the others have mentioned,
it may be that you are a victim of Jet Sandbox Mode. Is this function
being called in a query? Are you running Jet 4.0 SP7 or later? See if
this Microsoft KnowledgeBase article applies:

http://support.microsoft.com/default.aspx?scid=kb;en-us;294698
HOW TO: Block Unsafe Visual Basic for Applications Functions in
Microsoft Jet 4.0 Expression By Using Sandbox Mode