A very simple query in a database is working perfectly on any computer I have exept on 2.
There I get the message
Undefined Function 'Right' in Expression
I looked for the visual basic editaotr references.
Visual Basic for applications is the first. it is checked and I can not uncheck it as functions of it are used in the database code.
When I cloese the database, of course I can not access the references any more.
I copied the files needed from a working computer to the problem computer, I disinstalled VBA and access and installed it again. Nothing helps.
So what is next?