Autogenerated column value in access

[RRsonawane11]

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]

This will do it!

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)>

[NeoPa]

...
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).