<!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.2730.1700" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Thanks -- forcing the Null did work after all. I
guess when I was working on it last night I just didn't follow through long
enough. I tried a Date and a String variable and neither seemed to work. This
morning I changed the variable to a Variant and set it to "Null" -- and it's
working now. Thanks so much.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Susan H. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT><BR> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<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></DIV>
<DIV><FONT face=Arial size=2></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.<BR></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>