-
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.
-
Do Until cn.EOF
If IsNull(cn.has_read) = False Then
MsgBox cn.has_read
End If
cn.MoveNext
Loop