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
| Private Sub prev_Click()
Dim db As DAO.DataBase
Set db = OpenDatabase("BDD.mdb")
If Option1.Value = True Then
Set req_ent = db.OpenRecordset("SELECT * FROM TAB_DEVIS Where Categorie LIKE '" _
& TRes.Text & "*' ", adOpenDynamic)
End If
If Option2.Value = True Then
Set req_ent = db.OpenRecordset("SELECT * FROM TAB_DEVIS Where Appellation LIKE ('" _
& TRes.Text & "*') ", adOpenDynamic)
End If
If Option3.Value = True Then
Set req_ent = db.OpenRecordset("SELECT * FROM TAB_DEVIS Where Cru LIKE '" _
& TRes.Text & "*' ", adOpenDynamic)
End If
If Option4.Value = True Then
Set req_ent = db.OpenRecordset("SELECT * FROM TAB_DEVIS Where Titre LIKE '" _
& TRes.Text & "*' ", adOpenDynamic)
End If
If Option5.Value = True Then
Set req_ent = db.OpenRecordset("SELECT * FROM TAB_DEVIS Where Fournisseur LIKE '" _
& TRes.Text & "*' ", adOpenDynamic)
End If
If Option6.Value = True Then
Set req_ent = db.OpenRecordset("SELECT * FROM TAB_DEVIS Where Contenant LIKE '" _
& TRes.Text & "*' ", adOpenDynamic)
End If
If Option7.Value = True Then
Set req_ent = db.OpenRecordset("SELECT * FROM TAB_DEVIS Where Millesime LIKE '" _
& TRes.Text & "*' ", adOpenDynamic)
End If
If Option8.Value = True Then
Set req_ent = db.OpenRecordset("SELECT * FROM TAB_DEVIS Where Prix LIKE '" _
& TRes.Text & "*' ", adOpenDynamic)
End If
If Option9.Value = True Then
Set req_ent = db.OpenRecordset("SELECT * FROM TAB_DEVIS Where Rangement LIKE '" _
& TRes.Text & "*' ", adOpenDynamic)
End If
If req_ent.RecordCount > 0 Then
req_ent.MovePrevious
If req_ent.BOF Then
Rep = MsgBox("Plus d'objet trouvé!", vbCritical)
Else
Rcat = req_ent!categorie
Rapp = req_ent!Appellation
Rtit = req_ent!cru
Rcru = req_ent!Titre
Rfou = req_ent!fournisseur
Rcon = req_ent!contenant
Rmil = req_ent!Millesime
Rsol = req_ent!Solde
Rprix = req_ent!prix
Rran = req_ent!Rangement
End If
Else
Rep = MsgBox("Aucun objet n'a était trouvé!", vbInformation, "Confirmation")
End If
req_ent.Close
db.Close
End Sub |
Partager