Perry Harold
pharold at cfl.rr.com
Tue May 10 16:36:48 CDT 2011
If you switch from Access to VB it hits you in the teeth almost immediately. Perry ----- Original Message ----- From: "Stuart McLachlan" <stuart at lexacorp.com.pg> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Monday, May 09, 2011 5:50 PM Subject: Re: [AccessD] Need Some help > 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 >