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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

autoNumber

Status
Not open for further replies.

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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top