<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2726.2500" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><STRONG>Susan,</STRONG></DIV>
<DIV><STRONG></STRONG> </DIV>
<DIV> Apparently you are yet to try out the suggestions.
It would be nice if you could kindly do so and
<STRONG><EM>then</EM></STRONG> confirm the outcome.</DIV>
<DIV> </DIV>
<DIV> It may kindly be noted that there is no need at all
to worry about changing the structure of data table. If
you<STRONG><EM> know</EM></STRONG> that the table does not carry any
default value in the date field, go for the simpler statement i.e. (b). If in
any doubt, stick to the one at (a) which is effective in all cases.</DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV><STRONG>A.D.Tejpal</STRONG></DIV>
<DIV><STRONG>--------------</STRONG></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 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=ssharkins@bellsouth.net href="mailto:ssharkins@bellsouth.net">Susan
Harkins</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">Access Developers discussion and
problem solving</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, October 03, 2003
19:31</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] force Null
date/time data type value</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>I tried inserting Null and it didn't seem to work
-- but let me try again! ;) I want to avoid changing the actual structure,
because some records will have a date, some won't -- but that is an option
I've considered, but am hoping to avoid if possible. Thanks!</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Susan H. </FONT><BR> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV><STRONG>Susan,</STRONG></DIV>
<DIV><STRONG></STRONG> </DIV>
<DIV> Let the table T_Books consist of fields
Author(text), Title(text) and RefDate(date type). Both the following
statements will append a record having Null value in the date field -</DIV>
<DIV> </DIV>
<DIV> (a) If default value of RefDate is not Null -</DIV>
<DIV> DoCmd.RunSQL "INSERT INTO
T_Books " & _<BR>
"(Author, Title, RefDate) "
& _</DIV>
<DIV>
"Values('AAA', 'TTT' , Null) ;"</DIV>
<DIV> </DIV>
<DIV> (b) If default value of RefDate is already set as
Null - </DIV>
<DIV> DoCmd.RunSQL "INSERT
INTO T_Books " & _<BR>
"(Author, Title) " & _</DIV>
<DIV>
<DIV>
"Values('AAA', 'TTT') ;"</DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV><STRONG>A.D.Tejpal</STRONG></DIV>
<DIV><STRONG>--------------</STRONG></DIV></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 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=ssharkins@bellsouth.net
href="mailto:ssharkins@bellsouth.net">Susan Harkins</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> Friday, October 03, 2003
06:16</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [AccessD] force Null
date/time data type value</DIV>
<DIV><BR></DIV>I'm using INSERT INTO to append records. When a text string
isn't<BR>appropriate, I can use a zero-length string, but not the dates --
I've found<BR>no way to force a Null value using INSERT INTO. Any
help?<BR><BR>Susan H.</BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>