Link to home
Start Free TrialLog in
Avatar of superabbe
superabbe

asked on

Invalid use of Null: 'cInt'

Recive that error on following line, code worked yesterday.

If cInt(intPreviousTicketNumber) <> cInt(intTicketNumber) Then

Have the variable intPreviousTicketNumber = 0 at the beginning of the code.
Avatar of weesiong
weesiong

superrabbe,

Try this:

IF intPreviousTicketNumber <> "" And intTicketNumber <> "" Then
If cInt(intPreviousTicketNumber) <> cInt(intTicketNumber) Then

End If
End IF

Regards,
Wee Siong

ASKER CERTIFIED SOLUTION
Avatar of sybe
sybe

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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 ...