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
| Private Sub Command27_Click()
Dim db As DAO.Database
Dim sQuery As String
Set db = CurrentDb
sQuery = "UPDATE tbl_DCR " & _
"set MID(tbl_DCR.SB_N°, 1, 7) = [tbl_Extract_Suprem.SB Number]," & _
"[tbl_DCR.SB_rev] = [tbl_Extract_Suprem.SB Revision], " & _
"[tbl_DCR.DM/DFM] = [tbl_Extract_Suprem.DFM Name]," & _
"[tbl_DCR.DM/DFM_WorkCenter] = [tbl_Extract_Suprem.D(F)M Work center], " & _
"[tbl_DCR.SB_Designer] = [tbl_Extract_Suprem.SB Prep Resp]," & _
"[tbl_DCR.SB_Designer_WorkCenter] = [tbl_Extract_Suprem.SB Designer Work center] " & _
"[tbl_DCR.SB_Author] = [tbl_Extract_Suprem.Author name]," & _
"[tbl_DCR.SB_Author_WorkCenter] = [tbl_Extract_Suprem.SB author leader Work center] " & _
" FROM tbl_DCR INNER JOIN tbl_Extract_Suprem ON MID(tbl_DCR.SB_N°, 1, 7) = [tbl_Extract_Suprem.SB Number] and [tbl_DCR.SB_rev] = [tbl_Extract_Suprem.SB Revision] ;"
'éxécution de la transaction
On Error GoTo err_insert
DBEngine.Workspaces(0).BeginTrans
db.Execute sQuery, dbFailOnError
DBEngine.Workspaces(0).CommitTrans
MsgBox "Procédure effectuée avec succès..", vbOKOnly
Exit Sub
'si erreur
err_insert:
'annulation de la transaction
DBEngine.Workspaces(0).Rollback
MsgBox Err.Description
End Sub |
Partager