Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / May 2006

Tip: Looking for answers? Try searching our database.

Runtime Error 3075 because of LCase()

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Justin - 26 May 2006 16:58 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.