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
|
Private Sub btValider_Click()
On Error Resume Next
Dim ctl As Control
Dim sSQL As String
Dim sWhereClause As String
'Initialisation de la variable de la clause Where.
sWhereClause = " Where "
'Début de la première partie de l'instruction Select.
sSQL = "select * from contacts "
For Each ctl In Me.Controls
With ctl
Select Case .ControlType
Case acTextBox
.SetFocus
'Voici la fonction qui construit
'la clause.
If sWhereClause = " Where " Then
sWhereClause = sWhereClause & BuildCriteria(.Name, dbText, .Text)
Else
sWhereClause = sWhereClause & " and " & BuildCriteria(.Name, dbText, .Text)
End If
End Select
End With
Next ctl
'Définit le recordsource du sous-formulaire comme étant égal à la nouvelle
'instruction Select.
Form.form_resultats.txtSQL = sSQL & sWhereClause
Form.form_resultats.RecordSource = sSQL & sWhereClause
Form.form_resultats.Requery
End Sub |
Partager