Error message "Undefined function ..."

  • Thread starter Thread starter Gabriel Maraqa
  • Start date Start date
G

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
 
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!)
 
Gabriel Maraqa said:
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
Click to expand...

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
 
Back
Top