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 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147
|
Option Compare Database
Option Explicit
Private Sub chkDC_Click()
If Me.chkDC Then
SQL = SQL & "ORDER BY [PATIENTS]![DC] ASC;"
End If
End Sub
Private Sub chkNomEtude_Click()
If Me.chkNomEtude Then
Me.cmbRechNomEtude.Visible = False
Else
Me.cmbRechNomEtude.Visible = True
End If
RefreshQuery
End Sub
Private Sub chkNomInvestigateur_Click()
If Me.chkNomInvestigateur Then
Me.cmbRechNomInvestigateur.Visible = False
Else
Me.cmbRechNomInvestigateur.Visible = True
End If
RefreshQuery
End Sub
Private Sub chkTYPEDEPATHOLOGIE_Click()
If Me.chkTYPEDEPATHOLOGIE Then
Me.cmbRechTYPEDEPATHOLOGIE.Visible = False
Else
Me.cmbRechTYPEDEPATHOLOGIE.Visible = True
End If
RefreshQuery
End Sub
Private Sub cmbRechNomEtude_BeforeUpdate(Cancel As Integer)
RefreshQuery
End Sub
Private Sub cmbRechNomInvestigateur_BeforeUpdate(Cancel As Integer)
RefreshQuery
End Sub
Private Sub cmbRechTYPEDEPATHOLOGIE_BeforeUpdate(Cancel As Integer)
RefreshQuery
End Sub
Private Sub Form_Load()
Dim ctl As Control
For Each ctl In Me.Controls
Select Case Left(ctl.Name, 3)
Case "chk"
ctl.Value = -1
Case "lbl"
ctl.Caption = "- * - * -"
Case "txt"
ctl.Visible = False
ctl.Value = ""
Case "cmb"
ctl.Visible = False
End Select
Next ctl
Me.lstResults.RowSource = "SELECT Reclin, NOM,PRENOM, NOMETUDE, NOMINVESTIGATEUR, TYPEDEPATHOLOGIE FROM Patients;"
Me.lstResults.Requery
End Sub
Private Sub RefreshQuery()
Dim SQL As String
Dim SQLWhere As String
SQL = "SELECT Reclin, NOM, PRENOM, NOMETUDE, NOMINVESTIGATEUR, TYPEDEPATHOLOGIE FROM Patients Where Patients!Reclin <> 0 "
If Not Me.chkNomEtude Then
If Len(chkNomEtude) > 0 Then
SQL = SQL & "And Patients!NomEtude = '" & Me.cmbRechNomEtude & "' "
End If
End If
If Not Me.chkNomInvestigateur Then
If Len(chkNomInvestigateur) > 0 Then
SQL = SQL & "And Patients!NomInvestigateur = '" & Me.cmbRechNomInvestigateur & "' "
End If
End If
If Not Me.chkTYPEDEPATHOLOGIE Then
If Len(chkTYPEDEPATHOLOGIE) > 0 Then
SQL = SQL & "And Patients!TYPEDEPATHOLOGIE = '" & Me.cmbRechTYPEDEPATHOLOGIE & "' "
End If
End If
SQLWhere = Trim(Right(SQL, Len(SQL) - InStr(SQL, "Where ") - Len("Where ") + 1))
SQL = SQL & ";"
Me.lblStats.Caption = DCount("*", "Patients", SQLWhere) & " / " & DCount("*", "Patients")
Me.lstResults.RowSource = SQL
Me.lstResults.Requery
Dim Nbtotal, Resul As Integer
Nbtotal = DCount("*", "Patients")
Resul = DCount("*", "Patients", SQLWhere)
Me.Texte50 = (Resul / Nbtotal) * 100
End Sub
Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
End Sub
Private Sub lstResults_DblClick(Cancel As Integer)
DoCmd.OpenForm "FORM PATIENTSMULTCRIT", acNormal, , "[RECLIN] = " & Me.lstResults
End Sub |
Partager