<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1141" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=560350710-09042003><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV> </DIV><!-- Converted from text/plain format -->
<P><FONT size=2>Andy Lacey<BR><A
href="http://www.minstersystems.co.uk/">http://www.minstersystems.co.uk</A><BR><BR></FONT></P>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>Software
Design & Solutions Pty Ltd.<BR><B>Sent:</B> 09 April 2003
11:05<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> Re:
[AccessD] HELP - Date in SQL string<BR><BR></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>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??</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Kath</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=gustav@cactus.dk href="mailto:gustav@cactus.dk">Gustav Brock</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, April 09, 2003 6:24
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] HELP - Date in
SQL string</DIV>
<DIV><BR></DIV>Hi Kath<BR><BR>Did you try to bracket your field
name:<BR><BR> strsql = "INSERT INTO tblItemsInQuote (quoteID, [Date],
Sequence)
..<BR><BR>/gustav<BR><BR>_______________________________________________<BR>AccessD
mailing list<BR><A
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR><A
href="http://databaseadvisors.com/mailman/listinfo/accessd">http://databaseadvisors.com/mailman/listinfo/accessd</A><BR>Website:
<A
href="http://www.databaseadvisors.com">http://www.databaseadvisors.com</A><BR></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>