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
|
Option Compare Database
Private Sub chkCivilite_Click()
If Me.chkCivilite Then
Me.cmbRechCivilite.Visible = False
Else
Me.cmbRechCivilite.Visible = True
End If
RefreshQuery
End Sub
Private Sub cmbRechCivilite_BeforeUpdate(Cancel As Integer)
RefreshQuery
End Sub
Private Sub Commande0_click()
DoCmd.SendObject OutputFormat:=acFormatTXT, _
To:=Me.lstResults.Value, Cc:="", _
Subject:="Envoyer un e-mail", MessageText:="Ceci est un essai !"
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 tbl_particulier.num_part, tbl_particulier.nom_part, tbl_particulier.prenom_part, tbl_particulier.adresse_part, tbl_civilite.libel_civilite FROM tbl_civilite INNER JOIN tbl_particulier ON tbl_civilite.num_civilite=tbl_particulier.[num_civilite#] ORDER BY tbl_particulier.num_part; "
Me.lstResults.Requery
End Sub
Private Sub RefreshQuery()
Dim SQL As String
Dim SQLWhere As String
'SQL = "SELECT tbl_particulier.num_part, tbl_particulier.nom_part, tbl_particulier.prenom_part, tbl_particulier.adresse_part, tbl_civilite.libel_civilite FROM tbl_civilite INNER JOIN tbl_particulier ON tbl_civilite.num_civilite=tbl_particulier.[num_civilite#] ORDER BY tbl_particulier.num_part <> 0 "
If Me.chkCivilite Then
SQL = "SELECT num_part, nom_part, prenom_part, adresse_part, libel_civilite, email_part " & _
"FROM tbl_civilite INNER JOIN tbl_particulier ON tbl_civilite.num_civilite=tbl_particulier.[num_civilite#] " & _
"WHERE tbl_civilite!num_civilite <> 0 "
Else
SQL = "SELECT num_part, nom_part, prenom_part, adresse_part, libel_civilite, email_part " & _
"FROM tbl_civilite INNER JOIN tbl_particulier ON tbl_civilite.num_civilite=tbl_particulier.[num_civilite#] " & _
"WHERE tbl_civilite!num_civilite <> 0 " & _
"AND tbl_civilite!num_civilite like '*" & Me.cmbRechCivilite & "*' "
End If
SQLWhere = Trim(Right(SQL, Len(SQL) - InStr(SQL, "Where ") - Len("Where ") + 1))
SQL = SQL & ";"
Me.lstResults.RowSource = SQL
Me.lstResults.Requery
End Sub
Private Sub lstResults_DblClick(Cancel As Integer)
DoCmd.OpenForm "Formu_Particulier", acNormal, , "[num_part] = " & Me.lstResults
End Sub |
Partager