[AccessD] HELP - Date in SQL string

I think it would Kath, but using a reserved word as a field name means
having to remember to do that the whole time. You also have to be very
careful in code too. I once made this mistake myself. I had my field
called Date on a form, referred to in code (blahblah=me.Date) and Access
got its knickers in a right old twist. Didn't know what I was referring
to and even corrupted the form IIRC. Had to rename the field AND build a
new form. Right old mess. Definitely better not to go down that route.
 
 

Andy Lacey
http://www.minstersystems.co.uk <http://www.minstersystems.co.uk/> 



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Software
Design & Solutions Pty Ltd.
Sent: 09 April 2003 11:05
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] HELP - Date in SQL string


To tell you the truth Gustav now that I've had to change the field name
(slap wrist) in the BE and throughout the FE I don't want to go back and
try that - but when I had that error the field was not bracketed. Maybe
that would have worked??
 
Kath

----- Original Message ----- 
From: Gustav Brock <mailto:gustav at cactus.dk>  
To: accessd at databaseadvisors.com 
Sent: Wednesday, April 09, 2003 6:24 PM
Subject: Re: [AccessD] HELP - Date in SQL string

Hi Kath

Did you try to bracket your field name:

  strsql = "INSERT INTO tblItemsInQuote (quoteID, [Date], Sequence) ..

/gustav

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030409/8d0de8e1/attachment-0001.html>