1 2 3 4 5 6 7 8 9 10 11 12 13
| Private Sub Form_AfterUpdate()
Dim Sql As String
Sql = "SELECT T_PROFESSIONNEL_SANTE.s_nom, T_PROFESSIONNEL_SANTE.s_prenom, T_PROFESSIONNEL_SANTE.s_specialite, T_PROFESSIONNEL_SANTE.s_mode_exercice, T_PROFESSIONNEL_SANTE.s_adhesion, TS_SPECIALITE.specialite_txt, TS_MODE_EXERCICE.mode_exercice_txt, T_PROFESSIONNEL_SANTE.codeprof INTO T_PATIENT_PROF"
Sql = Sql & " FROM TS_MODE_EXERCICE RIGHT JOIN (TS_SPECIALITE RIGHT JOIN T_PROFESSIONNEL_SANTE ON TS_SPECIALITE.specialite = T_PROFESSIONNEL_SANTE.s_specialite) ON TS_MODE_EXERCICE.mode_exercice = T_PROFESSIONNEL_SANTE.s_mode_exercice;"
DoCmd.DeleteObject acQuery, "R_PATIENT_PROF"
CurrentDb.CreateQueryDef "R_PATIENT_PROF", Sql
DoCmd.SetWarnings False
DoCmd.OpenQuery "R_PATIENT_PROF"
DoCmd.SetWarnings True
End Sub |
Partager