1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| Private Sub txt_no_Click()
'Me.txt_no = (15000 + Nz(DCount("[no]", "Transaction", "[no] Like '" & 15000 & "*'"), 0) + 1)
' Me.txt_no = Nz(DCount("[no]", "Transaction", "[no] Like '" & 15000 & "*'"), 0)
'Me.txt_no = Int((15000 - 1000 + 1) * Rnd + 1000)
'Me.txt_no = CStr((15000) + Nz(DCount("*", "transaction"), 0) + 1)
'Me.txt_no = Nz(DMax("no", "Transaction"), 0) + 1
'Me.txt_no = CStr((10000) + Nz(DCount("No", "transaction"), 0) + 1)
'Dim StrSQL As String
' StrSQL = "INSERT INTO transaction (no)"
' StrSQL = StrSQL & "SELECT DMax('no', 'transaction', 'no > ' & 14999 & ' AND ' & 'no <' & 100000)+1 AS Expr1"
' CurrentDb.Execute StrSQL, dbFailOnError
'MsgBox ("No trouvé : " & txt_no)
End Sub |
Partager