<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2719.2200" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=472420114-25032003><FONT color=#0000ff
size=2>Barbara,</FONT></SPAN></DIV>
<DIV><SPAN class=472420114-25032003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=472420114-25032003><FONT color=#0000ff size=2>Just ignore the
time portion until you are ready to print the report. There is nothing you
can do about deleting the time portion from the Date datatype since it is really
a DateTime datatype. On the report you will want to format dtDate so as to
not show any time.</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV> </DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=en-us><B><FONT color=#0000ff>Charles Wortz</FONT></B></SPAN>
<BR><SPAN lang=en-us><FONT color=#0000ff>Software Development
Division</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Texas Education
Agency</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>1701 N. Congress
Ave</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Austin, TX
78701-1494</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>512-463-9493</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>CWortz@tea.state.tx.us</FONT></SPAN> </P>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us 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 2003 Mar 25
08:02<BR><B>To:</B> accessd@databaseadvisors.com<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></BLOCKQUOTE></BODY></HTML>