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 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
| Sub CreerEnrTableau()
Dim oRS As Recordset
Dim strDebut As String
Dim strTemp As String
Dim strFin As String
Dim strNouvelEnr As String
  Set oRS = CurrentDb.OpenRecordset("TableSource", 2)
  
  On Error Resume Next
  With oRS
    Do While Not .EOF
        strDebut = Left(.Fields("LeChamp"), 3)
        Do While Not .EOF
           If Left(.Fields("LeChamp"), 3) = strDebut Then
              strFin = strFin & Right(.Fields("LeChamp"), 1)
           Else
              strNouvelEnr = strDebut & " - " & strFin
              AjouterEnr strNouvelEnr
              strFin = Right(.Fields("LeChamp"), 1)
              Exit Do
           End If
          .MoveNext
        Loop
    .MoveNext
    Loop
    strNouvelEnr = strDebut & " - " & strFin
    AjouterEnr strNouvelEnr
    .Close
  End With
  Set oRS = Nothing
End Sub
Private Sub AjouterEnr(nouvelEnr As String)
Dim SQL As String
  
  SQL = "INSERT INTO TableDestination (LeChamp) VALUES _
  (" & Chr(34) & nouvelEnr & Chr(34) & ");"
  CurrentDb.Execute SQL, dbSeeChanges
End Sub |
Partager