superabbe
asked on
Invalid use of Null: 'cInt'
Recive that error on following line, code worked yesterday.
If cInt(intPreviousTicketNumb er) <> cInt(intTicketNumber) Then
Have the variable intPreviousTicketNumber = 0 at the beginning of the code.
If cInt(intPreviousTicketNumb
Have the variable intPreviousTicketNumber = 0 at the beginning of the code.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
before using your variable use isNull function.
in your example isNull(intTicketNumber)
what you can do is :
if isNull(intTicketNumber) then ...
OR
if Not isNull(intTicketNumber) then ...
in your example isNull(intTicketNumber)
what you can do is :
if isNull(intTicketNumber) then ...
OR
if Not isNull(intTicketNumber) then ...
Try this:
IF intPreviousTicketNumber <> "" And intTicketNumber <> "" Then
If cInt(intPreviousTicketNumb
End If
End IF
Regards,
Wee Siong