Software Design & Solutions Pty Ltd.
SDSSoftware at Optusnet.com.au
Wed Apr 9 05:05:26 CDT 2003
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
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/6509d152/attachment-0001.html>