Hi,
Can't really convert string to long.. or int.. Pls enlighten me?
thanks...

'Serial Number is number value in access database
Dim StockVerification As New OleDbCommand("SELECT serial_number from stock where serial_number = '" + txbRentalSerial.Text + "'", cnnRental)

'will prompt 'data mismatch' when executing the program
Tried using below and cant also...

Dim mylong As Long
Dim s As String
'mylongl = CLng(txbRentalSerial.Text)
'mylong = System.Convert.ToInt64(txbRentalSerial.Text())