undefined function in expression

  • Thread starter Thread starter Tim
  • Start date Start date
T

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