Andy Lacey
andy at minstersystems.co.uk
Tue Jan 8 14:47:57 CST 2013
Hi Tony I wish my memory was better but I've had this before and I'm pretty sure it's one of two things. It may be cured by a Repair but if not I'm sure it's a Reference issue. Wish I could remember which but if a Repair doesn't cure it look at the References. Andy -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav Sent: 08 January 2013 20:28 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] ACCESS2003 Function is not Expression Thanks Paul Doesn't seem to be causing the problem. I tried doing another query using a different table and FLetter:Left([FName],1) and still got the error message -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Paul Hartland Sent: January-08-13 2:01 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] ACCESS2003 Function is not Expression Just a thought, is the error with Char in Char:Left([keyword],1) the reason off hand that I think of this is that isn't Char a reserved word in Access ? Paul On 8 January 2013 19:43, Tony Septav <TSeptav at uniserve.com> wrote: > Hey All > > Interesting, if is use > > 1. First Char:Left([keyword],1) in a query grid it raises an error message. > > 2. MsgBox Left(rst!keyword,1) in a recordset it works fine > > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Paul Hartland paul.hartland at googlemail.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