undefined function in expression

[Tim]

Hi, I am hoping someone can help with a very frustrating problem. One user
is getting a "undefined function 'right' in expression" error message when
opening a report. No one else is having the problem, and if the user logs in
on another machine, the problem does not occur.

I've tried:
-"Detect and Repair"
-uninstalling/reinstalling access
-uninstalling/reinstalling office 2000
-applied all Windows/Office updates

Nothing works. My last option is to reimage this machine, but I thought I
would try getting help here. Any ideas?

 

[Cheryl Fischer]

This error would suggest that there is a reference problem on the machine
exhibiting the error. Files used in references must be located in exactly
the same path\file as specified in the MDB.

Here are a couple of links with info on fixing reference problems:

http://allenbrowne.com/ser-38.html

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

 

[Sandra Daigle]

This is probably a problem with references - check Doug Steele's article for
the full story
(http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html).

 

[Joan Wild]

This is a sign of a missing reference.

See
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

 

[Guest]

Possibility: That particular User may have something set
in their Options property that's causing this to happen.
Get on their computer, open the Access application, go to
Options, and look through each property setting to see if
there is anything that may be conflicting. If there is,
check with the User before resetting the property, for he
may have set it that way because another Access database
he uses required that setting. If so, write code in your
database upon opening (you can use the Autoexec macro)
that sets that property to what you need. The property
will reset to where he needs it after closing your
database, so it's a win-win.

 

[Sean]

I think the user's machine is at fault.
I think the machine is missing a reference.
open up the mdb on that machine and check the references to see which one is
missing. or if you have a setup program then just rerun that.
The right function error is a red herring....