1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| Set db = DBEngine.OpenDatabase("D:\Documents and Settings\triou\Mes documents\creaCompte\sharepoint-v2.0.mdb")
sSQLSSC = "Select * From tblSSCRequest"
Set rstSharepoint = db.OpenRecordset(sSQLSSC, dbOpenForwardOnly, dbReadOnly)
Do Until rstSharepoint.EOF Or rstSharepoint![Adresse Email] = Me.cbxEmailAddress
rstSharepoint.MoveNext
Loop
sSQLSSC = "Insert Into [tblSSCRequest]"
sSQLSSC = sSQLSSC & "(tblSSCRequest.Edit, tblSSCRequest.[Adresse Email], tblSSCRequest.[Répertoires désirés], tblSSCRequest.[Entité SSB], tblSSCRequest.Statut, tblSSCRequest.Société, tblSSCRequest.Téléphone)"
sSQLSSC = sSQLSSC & "values("
sSQLSSC = sSQLSSC & "'" & rstSharepoint![Edit] & "',"
sSQLSSC = sSQLSSC & "'" & rstSharepoint![Adresse Email] & "',"
sSQLSSC = sSQLSSC & "'" & rstSharepoint![Répertoires désirés] & "',"
sSQLSSC = sSQLSSC & "'" & rstSharepoint![Entité SSB] & "',"
sSQLSSC = sSQLSSC & "'" & "Etape 2" & "',"
sSQLSSC = sSQLSSC & "'" & rstSharepoint![Société] & "',"
sSQLSSC = sSQLSSC & "'" & rstSharepoint![Téléphone] & "'"
sSQLSSC = sSQLSSC & ");"
DoCmd.RunSQL sSQLSSC |
Partager