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 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71
| Private Sub b_p_envoi_new_suite_Click()
Dim creat_sql As String
Dim rs As DAO.Recordset
Dim compt As Integer
Dim obj As AccessObject
For Each obj In Application.CurrentData.AllTables
If obj.Name = "TEMPORAIRE" Then
If obj.IsLoaded Then
DoCmd.Close acTable, "TEMPORAIRE", acSaveNo
End If
DoCmd.DeleteObject acTable, "TEMPORAIRE"
End If
Next obj
creat_sql = "CREATE TABLE TEMPORAIRE"
creat_sql = creat_sql + " ([nom_temp] text (70),"
creat_sql = creat_sql + " [date_temp] date,"
creat_sql = creat_sql + " [salle_temp] text (5),"
creat_sql = creat_sql + " [mairie_temp] text (5),"
creat_sql = creat_sql + " [agence_temp] text (5),"
creat_sql = creat_sql + " [centre_temp] text (5),"
creat_sql = creat_sql + " [comite_temp] text (5),"
creat_sql = creat_sql + " [divers_temp] text (5),"
creat_sql = creat_sql + " [envoi_temp] text (8),"
creat_sql = creat_sql + " [restrict_temp] text (8)"
For compt = 1 To Forms![envoi_new]![liste_document_select].ListCount
document = "document" & compt
creat_sql = creat_sql + ", [" & document & "] integer"
Next compt
creat_sql = creat_sql + ")"
DoCmd.RunSQL creat_sql
Set rs = Application.CurrentDb.OpenRecordset("TEMPORAIRE", dbOpenDynaset)
rs.AddNew
rs.Fields("nom_temp") = nom_envoi
rs.Fields("date_temp") = date_envoi
rs.Fields("salle_temp") = option_salle
rs.Fields("mairie_temp") = option_mairie
rs.Fields("agence_temp") = option_agence
rs.Fields("centre_temp") = option_centre_commerciaux
rs.Fields("comite_temp") = option_comite_entreprise
rs.Fields("divers_temp") = option_divers
For compt = 1 To Forms![envoi_new]![liste_document_select].ListCount
rs.Fields("document" & compt).Value = Forms![envoi_new]![liste_document_select].Column(0, compt - 1)
Next compt
rs.Update
rs.Close
DoCmd.Close acForm, "envoi_new"
On Error GoTo Err_b_p_envoi_new_suite_Click
Dim stdocname As String
Dim stlinkcriteria As String
stdocname = "envoi_new_suite"
DoCmd.OpenForm stdocname, , , stlinkcriteria
Exit_b_p_envoi_new_suite_Click:
Exit Sub
Err_b_p_envoi_new_suite_Click:
MsgBox Err.Description
Resume Exit_b_p_envoi_new_suite_Click
End Sub |
Partager