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 42 43 44 45 46 47 48 49
|
ublic Function sansAccent(ByVal Chaine As String, EnMinuscule As Boolean) As String
Chaine = UCase(Chaine)
Chaine = Replace(Chaine, Chr(232), "e")
Chaine = Replace(Chaine, Chr(233), "e")
Chaine = Replace(Chaine, Chr(234), "e")
Chaine = Replace(Chaine, Chr(235), "e")
Chaine = Replace(Chaine, Chr(249), "u")
Chaine = Replace(Chaine, Chr(250), "u")
Chaine = Replace(Chaine, Chr(251), "u")
Chaine = Replace(Chaine, Chr(242), "o")
Chaine = Replace(Chaine, Chr(244), "o")
Chaine = Replace(Chaine, Chr(254), "o")
Chaine = Replace(Chaine, Chr(255), "y")
Chaine = Replace(Chaine, Chr(224), "a")
Chaine = Replace(Chaine, Chr(225), "a")
Chaine = Replace(Chaine, Chr(226), "a")
Chaine = Replace(Chaine, Chr(238), "i")
Chaine = Replace(Chaine, Chr(239), "i")
Chaine = Replace(Chaine, Chr(244), "o")
If EnMinuscule Then Chaine = LCase(Chaine)
sansAccent = Chaine
End Function
Public Sub Norm()
Dim rst As DAO.Recordset
Dim strSql As String
Dim strPrenom As String
Set rst = CurrentDb.OpenRecordset("Test")
While Not rst.EOF
' mise à jour
rst.Edit
strPrenom = rst("Prénom")
DoCmd.RunSQL "SELECT [Prénom] FROM Test WHERE " & strPrenom & " =sansaccent(" & strPrenom & ",true)"
rst.Update
rst.MoveNext
Wend
rst.Clone
Set rst = Nothing
End Sub |
Partager