<!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>Thanks....that works
fine!..............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 9:02
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Problem with Date
type variable</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=037590014-25032003><FONT face=Arial color=#0000ff
size=2>Looks like yes. You could also check for CLng(dtDate) <>
0.</FONT></SPAN></DIV>
<P><FONT face=Arial><FONT size=2>Jim <SPAN
class=037590014-25032003>DeMarco</SPAN></FONT></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 9:02
AM<BR><B>To:</B> <A
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A><BR><B>Subject:</B>
Re: [AccessD] Problem with Date type variable<BR><BR></FONT></DIV>
<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></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>