Andy Lacey
andy at minstersystems.co.uk
Wed Apr 9 05:11:58 CDT 2003
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>