<!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 5.50.4522.1800" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I am importing data from a text file ----
only if the "date" in this import file is populated (i.e., NOT
blank/spaces), then the import date is moved to my date variable
("dtDate"). I then write the contents of dtDate (along with other data) to
a table, which is then printed on a report. Should I be checking "If
dtDate <> 12:00:00 AM, then write contents of dtDate to table
date?"</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks,</FONT></DIV>
<DIV><FONT face=Arial size=2>Barb</FONT></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=Jdemarco@hshhp.org href="mailto:Jdemarco@hshhp.org">Jim DeMarco</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> Tuesday, March 25, 2003 8:33
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Problem with Date
type variable</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=356343213-25032003><FONT face=Arial color=#0000ff
size=2>That's the zero value for a Date datatype. Any variable of this
type has this value until you fill it with a value.</FONT></SPAN></DIV>
<P><FONT face=Arial size=2>Thanks,</FONT> </P>
<P><FONT face=Arial size=2>Jim DeMarco</FONT> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Barbara Ryan
[mailto:BarbaraRyan@cox.net]<BR><B>Sent:</B> Tuesday, March 25, 2003 7:52
AM<BR><B>To:</B> Access List<BR><B>Subject:</B> [AccessD] Problem with Date
type variable<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>I am encountering a problem with date type
variables in Access 97. When I create a date type variable (e.g., "Dim
dtDate as Date") , the variable has a default value of 12:00:00 AM. I
don't remember this happening before.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I recently did a "cleanup" on my PC, removing
software I no longer use. Could I have removed a needed
driver(s)? I ask that question because I am also having a problem with
my printer (HP IIP Plus) not printing lines on reports (which it was doing
fine last week). </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Any thoughts?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks,</FONT></DIV>
<DIV><FONT face=Arial size=2>Barb Ryan</FONT></DIV></BLOCKQUOTE><CODE><FONT
size=3><BR><BR>***********************************************************************************<BR>"This
electronic message is intended to be for the use only of the named recipient,
and may contain information from HealthSource/Hudson Health Plan (HS/HHP) that
is confidential or privileged. If you are not the intended recipient, you are
hereby notified that any disclosure, copying, distribution or use of the
contents of this message is strictly prohibited. If you have received this
message in error or are not the named recipient, please notify us immediately,
either by contacting the sender at the electronic mail address noted above or
calling HS/HHP at (914) 631-1611. If you are not the intended recipient,
please do not forward this email to anyone, and delete and destroy all copies
of this message. Thank
You".<BR>***********************************************************************************<BR></FONT></CODE>
<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>