[AccessD] Problem with Date type variable

Barbara Ryan BarbaraRyan at cox.net
Tue Mar 25 08:54:52 CST 2003


Thanks....that works fine!..............Barb
  ----- Original Message ----- 
  From: Jim DeMarco 
  To: accessd at databaseadvisors.com 
  Sent: Tuesday, March 25, 2003 9:02 AM
  Subject: RE: [AccessD] Problem with Date type variable


  Looks like yes.  You could also check for CLng(dtDate) <> 0.
  Jim DeMarco

    -----Original Message-----
    From: Barbara Ryan [mailto:BarbaraRyan at cox.net]
    Sent: Tuesday, March 25, 2003 9:02 AM
    To: accessd at databaseadvisors.com
    Subject: Re: [AccessD] Problem with Date type variable


    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?"

    Thanks,
    Barb
      ----- Original Message ----- 
      From: Jim DeMarco 
      To: accessd at databaseadvisors.com 
      Sent: Tuesday, March 25, 2003 8:33 AM
      Subject: RE: [AccessD] Problem with Date type variable


      That's the zero value for a Date datatype.  Any variable of this type has this value until you fill it with a value.
      Thanks, 

      Jim DeMarco 

        -----Original Message-----
        From: Barbara Ryan [mailto:BarbaraRyan at cox.net]
        Sent: Tuesday, March 25, 2003 7:52 AM
        To: Access List
        Subject: [AccessD] Problem with Date type variable


        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.

        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).  

        Any thoughts?

        Thanks,
        Barb Ryan


      ***********************************************************************************
      "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".
      ***********************************************************************************



--------------------------------------------------------------------------


      _______________________________________________
      AccessD mailing list
      AccessD at databaseadvisors.com
      http://databaseadvisors.com/mailman/listinfo/accessd
      Website: http://www.databaseadvisors.com



  ***********************************************************************************
  "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".
  ***********************************************************************************



------------------------------------------------------------------------------


  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030325/67273287/attachment-0001.html>


More information about the AccessD mailing list