Runtime Error 3075 because of LCase()

  • Thread starter Thread starter Justin via AccessMonster.com
  • Start date 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!!
 
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
Runtime Error 3075 2
Insert into ..... Select statements. 4
Print contents of sub folders 1
Errors 2448 and 3075! 1
error 3075: functions such as CHR$ not working on Vista 2
Access 2007 Runtime Error 3075 5

Back
Top