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
|
'--------------------------------------------------
Public Sub Rec_Dupl()
'--------------------------------------------------
Dim dbs As Database
Dim tbl As Recordset
Dim SQLfield, SQLstring As String
Set dbs = CurrentDb
'--------------------------------------------
' Supprime la table temporaire si existe déjà
'--------------------------------------------
On Error Resume Next
dbs.Execute "DROP TABLE tbl_DEMandes_temp"
' ---------------------------------------------------
' Copie de l'enregistrement dans une table temporaire
' ---------------------------------------------------
SQLfield = _
"[DEM_Est_Terminé], [DEM_INFO_Terminé], " + _
"[DEM_GER_Terminé] , [DEM_Demandé_Le], [DEM_Effectué_Le], " + _
"[DEM_Texte], [STA_Est_Actif], [STA_Entrée_LE], " + _
"[STA_Sortie_Le], [PER_Nom], [PER_Prénom], " + _
"[PER_Initiales], [PER_SERvice], [PER_FONction], " + _
"[PER_SITe], [PER_No_Bureau], [SEC_POSI_Est_Signé], " + _
"[SEC_POSI_le], [SEC_AD_Actif], [SEC_AD_Référence], " + _
"[SEC_Logon], [SEC_X_Service], [SEC_AD_A_Mail_Perso], " + _
"[SEC_AD_Mail_Perso], [SEC_AD_Mail_Générique], [LOG_BUR_Office2007], " + _
"[LOG_BUR_Access], [LOG_BUR_Publisher], [LOG_BUR_Visio], " + _
"[LOG_ACG_Cimetières], [LOG_ACG_Crèches], [LOG_ACG_Ressources], " + _
"[LOG_ACG_Restos], [LOG_ACG_Sécurité_municipale], " + _
"[LOG_ACG_Infopop], [LOG_ACG_InfoPop_Accès], [LOG_ACG_InfoStar], " + _
"[LOG_ACG_Calvin_II], [LOG_ACG_Geeci], [LOG_FIN_Opale_Accès], " + _
"[LOG_FIN_Opale_Référence], [LOG_FIN_Profil], [LOG_FIN_Compta], " + _
"[LOG_FIN_Compta_Service], [LOG_FIN_Débiteurs], [LOG_FIN_Débiteurs_Service], " + _
"[LOG_FIN_Fournisseurs], [LOG_FIN_Engagements], [LOG_FIN_Engagements_Service], " + _
"[LOG_FIN_Salaires], [LOG_APP_Optimiso], [LOG_APP_FM], " + _
"[LOG_WEB_Meyrin], [LOG_WEB_Meyrin_Editeur], [LOG_WEB_CMnet], " + _
"[LOG_WEB_CMnet_Editeur], [LOG_WEB_intranet], [LOG_WEB_intranet_Editeur], " + _
"[LOG_WEB_Optimiso], [LOG_DIV_Autres], [GER_CLE_Nécessaire], " + _
"[GER_CLE_Reçue], [GER_CLE_Rendue], [GER_BUR_Corps_Bureau], " + _
"[GER_BUR_Partage_bureau], [GER_BUR_Etiquette_Porte], [GER_TEL_Existant], " + _
"[GER_TEL_Fixe], [GER_TEL_No_fixe], [GER_TEL_Mobile]"
SQLstring = _
"SELECT " + SQLfield + " INTO tbl_DEMandes_temp FROM tbl_DEMandes WHERE N°= " + Str(Form_frm_DEM.N°.Value)
dbs.Execute SQLstring
Set tbl = dbs.OpenRecordset("tbl_DEMandes_temp")
'.... suite
End Sub |
Partager