ok i've above is solved and all working well.
Earlier i had set the Basefare as string and now changed to Long. When running the app i get a "type mismatch" at
and the value in the variable is 0. Is it because long can't take values of 0 or is it something else. The data type in the table is also number
Earlier i had set the Basefare as string and now changed to Long. When running the app i get a "type mismatch" at
Code:
BaseFare = Trim(Mid(TextLine, 9, 12))