why do I get this error "undefined function 'left' in expression

  • Thread starter Thread starter vicbes
  • Start date Start date
V

vicbes

I am a new user of Access 2007.
This function worked in 2003 but will not work in 2007. The help button
displays You entered an SQL expression that includes a Function procedure
name that cannot be recognized.
However this is a valide function
 
vicbes said:
I am a new user of Access 2007.
This function worked in 2003 but will not work in 2007. The help button
displays You entered an SQL expression that includes a Function procedure
name that cannot be recognized.
However this is a valide function
Click to expand...

Another possibility, since this is Access 2007, is that Access has disabled
all VBA code as part of its default security settings. I think that would
apply to VBA functions used in queries, too, though I can't say for sure at
the moment.

Was there a warning when you opened the database saying something about
disabling VBA? Is the database in an official "trusted location"? If not,
you might try putting it in one -- say, your Documents folder -- or else use
the Trust Center to trust the location the database is currently in.
 
Back
Top