Hi Mohammed Qasem,
Pls don't use all capital letters this means shouting.
thanks,
ryan
>OK, MY MISTAKE
>
>I SEE 0 OR -ANY NUMBER.
>
> THANKS.
>>Please answer my question: What's the value for sticket and eticket when you get an error? I am NOT asking for lnSticket or lnEticket.
>>
>>I must remind you of what I have said before. In order to get something to work, it's essential that you know WHY and HOW something work, not only that it works. Please take the time to analyze all the tips you receive, as soon as you understand how the code works, you will also be able to do the necessary changes to the code.
>>
>>>hi,
>>>
>>>lnSticket = Val(SubStr(csrMyCursor.sticket, 4))=QQQ33 OR WWW60
>>>lnEticket = Val(SubStr(csrMyCursor.eticket, 4))=QQQ10 OR TTT20
>>>
>>>
>>>
>>>
>>>>What's the value for sticket and eticket when you get an error?
>>>>
>>>>>hi all,
>>>>>
>>>>>i try this code under ,
>>>>>sometime work, somtime not
>>>>>lnSticket = Val(SubStr(csrMyCursor.sticket, 4))
>>>>>lnEticket = Val(SubStr(csrMyCursor.eticket, 4))
>>>>>replace noofticket with lnSticket-lnEticket
>>>>>