[AccessD] Need Some help

And Value and Index...

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
Sent: Monday, May 09, 2011 5:55 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Need Some help

So true!

Let's not forget naming fields "Date, Month, Year" and "Name" :)

D

On Mon, May 9, 2011 at 2:50 PM, Stuart McLachlan
<stuart at lexacorp.com.pg>wrote:

> Advice to young developers:
>
> Never, ever, ever, ever , ever put spaces in the name of any  field or 
> object.  If you do, it WILL turn round and bite you one day.
>
> :-)
>
> --
> Stuart
>
> On 9 May 2011 at 13:18, Heenan, Lambert wrote:
>
> > Ah well. Now that the live parts of my brain have engaged (this is a 
> > Monday after all) it is evident that what was tripping you up was 
> > the spaces in the query name.
> >
> > Instead of the SQL string :"Select * From, Project Month And Year"
> >
> > You really needed :"Select * From [Project Month And Year]"
> >
> > Lambert :-)
> >
>
>
> --
> 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