[AccessD] ACCESS2003 Function is not Expression

 Generally when you see this, it's references.  However if they are broken,
it won't work anywhere else either.

 To double check, open the VBA editor, call up the debug window and type:

 ? Left("Tony",1)

 If that works, then references are OK.

 I would then try a query with a single column on that table with left() on
another field and see if it works.  If it does, then switch to the Keyword
field.

 Access 2010 BTW is a LOT picker about syntax and where/how things are used.

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav
Sent: Wednesday, January 09, 2013 03:05 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] ACCESS2003 Function is not Expression

Hey Gary
Thanks Kindly
I will do some checking. 
This thing has got me baffled. It works on my machine and the only
difference is the client's machine has Access 2010 installed.
Thanks again.

Tony Septav
Nanaimo, BC
Canada

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
Sent: January-09-13 1:57 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] ACCESS2003 Function is not Expression

Hi Tony,

Have you checked for missing references on your client's PC?

Sometimes it's a matter of changing the sequence of the references.

Here are some links that show how to check references that may be
applicable.

http://www.access-diva.com/d5.html

http://allenbrowne.com/ser-38.html

http://www.pcreview.co.uk/forums/undefined-function-date-expression-t1171993
.html

http://www.wiredbox.net/forum/Thread486297_Undefined_function_Date_in_expres
sion.aspx

http://www.anysitesupport.com/access-undefined-function-right-in-expression/

GK

On Tue, Jan 8, 2013 at 5:50 PM, Tony Septav <TSeptav at uniserve.com> wrote:
> Thanks to all who have responded
>
> It is a simple
>
> Variable response in a field in the Query Grid
>
> eg - Something: left([Field],1)
>
>
>
> I have tried the same thing using many different tables. Each query when
run
> generates the same error message on the client's machine (not mine).  As
> mentioned I have his laptop so I can try different scenarios.
>
> As many of you have mentioned (myself included) I have seen this before,
but
> thinking at the time I would never forget what caused the message I never
> wrote it down.
>
> I do not want any cheese with my "Whine", but Windows 7 security has
caused
> me endless grief in my coding.  The latest being, on my install I put the
> front end in a subfolder in the Program Files (or (x86) )folder, when the
> program tried to do a "repair and compact on exit" a message would appear
> telling me something like I did  not have ADMIN rights to do this.
>
> So I had to change my install location for the front end.
>
>
>
> This is "mystery meat" and I either solve it or rewrite it to come at it
> from a different direction. Ask me if I am frustrated.
>
>
>
> Thanks Again
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



-- 
Gary Kjos
garykjos at gmail.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com