Left Function working in Modules but not Queries

Question

I have one user of an Access database that is having a problem that has me stumped.  When the user executes a query that uses the Left function he gets the following error, "Function isn't available in expression in query expression 'Left([QryLastStatusUpdate]![Status], 500_'."  I can use the Left function in a Module on his computer without any problem.  I can not recreate his issue on my computer and there are dozens of other users who run the query every day without an error.  I verified that the reference to the dll was correct and I tried replacing the dll.

Any ideas are welcome.

Answer 1

The Left function itself is working just fine.  I am able to use it in Modules.  It just doesn't work for that one user when it is used in a query.

The query is the place it will fail. The VBA code will still work. Don't ask me why cuz I don't know but I've seen this happen lots of times and it was always either a missing reference or something wrong with the DAO DLL registration.

Answer 2

The Left function itself is working just fine.  I am able to use it in Modules.  It just doesn't work for that one user when it is used in a query.

Answer 3

That would be a typeO on my part.  The actual message had the correct right parenthesis.

Answer 4

If there are no missing references then you probably need to register the DAO DLL.

Answer 5

"Function isn't available in expression in query expression 'Left([QryLastStatusUpdate]![Status], 500_'."  

How many characters do you expect to return in the above?  

It has no closing parenthesis and 500 is followed by an underscore.