Sep 18, 2001 #1 wdu94 Programmer Aug 15, 2001 61 US Hi, All, I have a field in the table named "Compli_num". Compli_num ---------------- 01CF001 01CF002 01CF003 01CF004 ...... I want to know how to get this number auto-increment. Thank you for your time. Jeannia
Hi, All, I have a field in the table named "Compli_num". Compli_num ---------------- 01CF001 01CF002 01CF003 01CF004 ...... I want to know how to get this number auto-increment. Thank you for your time. Jeannia
Sep 24, 2001 #2 ide Programmer Apr 10, 2001 236 EU in table design i think you couldn't it. define the field as text and on a form create the default value. Add to this function the Max(Compli_num) and it returns the incremented value. Function IncHex(dd As String) IncHex = Hex(Val("&H" & dd) + 1) End Function Upvote 0 Downvote
in table design i think you couldn't it. define the field as text and on a form create the default value. Add to this function the Max(Compli_num) and it returns the incremented value. Function IncHex(dd As String) IncHex = Hex(Val("&H" & dd) + 1) End Function