[AccessD] Need Some help

David McAfee davidmcafee at gmail.com
Mon May 9 16:54:46 CDT 2011


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
>



More information about the AccessD mailing list