[AccessD] ACCESS2003 Function is not Expression

Is the keyword the same name as any functions in the MDB ?

On 8 January 2013 20:28, Tony Septav <TSeptav at uniserve.com> wrote:

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



-- 
Paul Hartland
paul.hartland at googlemail.com