Autogenerated column value in access

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • RRsonawane11
    New Member
    • Jan 2008
    • 11

    Autogenerated column value in access

    hi,
    i am designing a datebase i.e. User Master where i wan that user id is auto generated.i.e. whenever new user is created that user must get unique user id n which must be auto generated...
    for ex. suppose user id : usr1234 is exist then new user must get new user id as usr1235...like this....

    plz help fast...i ve to design a database...Hurr yyyyyyyyyyyy
  • missinglinq
    Recognized Expert Specialist
    • Nov 2006
    • 3533

    #2
    This will do it!

    Code:
    Private Sub Form_BeforeUpdate(Cancel As Integer)
     Me.UserID = "usr" & DMax("Mid([UserID],4,Len([UserID])-3)", "YourTableName") + 1
    End Sub
    Welcome To TheScripts!

    Linq ;0)>

    Comment

    • NeoPa
      Recognized Expert Moderator MVP
      • Oct 2006
      • 32656

      #3
      Originally posted by RRsonawane11
      ...
      plz help fast...i ve to design a database...Hurr yyyyyyyyyyyy
      Please use only proper English and patience on these forums (FAQ - How to Ask a Question).

      Comment

      Working...