Recent content by BeArkens

Hi all, Thanks for your replies. Some guidelines will surely help me completing this database. FYI the function that worked well for my issue was: Public Function StripZeros(pstr As String) As String Dim n As Integer n = 1 Do While Mid(pstr, n, 1) = "0" n = n + 1 Loop...

Sorry for your loss. My condolences to you and the family

Thanks Bob. This helps for the codes with the leading zeros. The other codes however get changed as well (incorrectly). This is what happed: 1) 000000000000001582 >1582 >ok 2) 01-06-0023-9 >1 >nok 3) NL230637612 > 0 > nok How can I make 1) happen, but 2) and 3) keep the original code...

Our product range includes letter codes and numeric codes. We upload these product codes (1 column) as a text field in access. This gives us egg. "000000000111" for code "111". 1 uploaded table (short) is an excel table that shows the code as "111". Can you help me to convert "000000000111"...