Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Chummly1984
- Content: Threads
- Order by date
-
Runtime Error 6
I am using this code, and am getting this error. If Len(txtESNdec) = 18 Then left10 = Left([txtESNdec], 10) right8 = Right([txtESNdec], 8) hexleft = Hex(left10) hexright = Hex(right8) hex_number = Format(hexleft, "00000000") & Format(hexright, "000000") Me.txtESNhex =...- Chummly1984
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Formating a text box
Have a quick question. Here is a code I am using to convert decimal serial numbers into Hex. Private Sub txtESNdec_AfterUpdate() left3 = Left([txtESNdec], 3) right8 = Right([txtESNdec], 8) hexleft = Hex(left3) hexright = Hex(right8) hex_number = hexleft...- Chummly1984
- Thread
- Replies: 12
- Forum: Microsoft: Access Forms
