Hi,
Just started at a new workplace and this error popped up on one of the user's
computer and I'm trying to fix it.
Basically there's a query that used LCase on one of its text fields, and the
following error occurs:
Runtime Error 3075: Function isn't available in expressions in query
expression 'LCase([address])'.
I've also just tried doing "SELECT LCase("ABC") from tempTable" and the same
error occurs.
Is it because of how my references are set up? Can anyone help??
Thanks in advance!!
arthurjr07@gmail.com - 29 May 2006 03:59 GMT
Maybe you have a MISSING Reference.
try to verify, Goto Visual Basic editor
then TOOLS>References.