Runtime Error 3075 because of LCase()

  • Thread starter Justin via AccessMonster.com
  • Start date
J

Justin via AccessMonster.com

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!!
 
A

arthurjr07

Maybe you have a MISSING Reference.

try to verify, Goto Visual Basic editor
then TOOLS>References.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Runtime Error '3075' 2
Access 2003 truncates code in queries 3
Error 3075 4
Access 2007 Runtime Error 3075 5
Query formatting for numbers. 2
error 3075: functions such as CHR$ not working on Vista 2
Errors 2448 and 3075! 1
Runtime ERR 3075 in VISTA 2

Top