Results 1 to 2 of 2

Thread: Date field in ActiveX

  1. #1

    Thread Starter
    Member
    Join Date
    Nov 1999
    Posts
    48
    I am new to using COM objects and followed the great tutorials posted on this site.

    My problem is that I am trying to access a date field that is null and keep getting "Invalid Use of Null" error.

    In VB, I know how to work around that, but no matter what I try using ActiveX, nothing works.

    Does anyone know of what to do about this. Obviously I am missing something, because it has to be done.

    example.
    My vb project that references the dll is codes as such:
    Dim cn As Mail
    Set cn = New Mail
    cn.conn

    Do Until cn.EOF
    MsgBox cn.has_read
    cn.MoveNext
    Loop

    has_read is the date that is null until user reads the mail. It works on the dates that are not null.

  2. #2
    Lively Member chrisgaddy's Avatar
    Join Date
    Mar 2001
    Location
    Olive Branch, MS
    Posts
    71
    Do Until cn.EOF
    If IsNull(cn.has_read) = False Then
    MsgBox cn.has_read
    End If
    cn.MoveNext
    Loop

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width