I have a system with a back end and and multi front end.
many user use it in the same time. i am using the below function to create transaction number.
the problem i am facing that if two user hit the button save in the same second. they will take the same number. one of them will be saved the other will have a problem
my front end is in accde format
any suggestions??
Public Sub CreatTransNum()
txtTransNum.Value = Nz(DMax("TransNum", "[TblSavedPrepSummary]")) + 1
End Sub
many user use it in the same time. i am using the below function to create transaction number.
the problem i am facing that if two user hit the button save in the same second. they will take the same number. one of them will be saved the other will have a problem
my front end is in accde format
any suggestions??
Public Sub CreatTransNum()
txtTransNum.Value = Nz(DMax("TransNum", "[TblSavedPrepSummary]")) + 1
End Sub