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
| Private Sub Form_Activate()
If Harissa.renseigne = True Then
ean128 = Harissa.ean128
ean128.SetFocus
SendKeys "{tab}"
SSCC = Harissa.SSCC
Q.SelStart = 0 ' pts de depart = 0
Q.SelLength = Len(DATED.Text) ' selectionne l ens du champs
End If
' met les valeurs a jour en sortie de la page harissa
If miseajour = True Then
'eclate le code ean128
GTIN = Mid(ean128, 3, 14)
lot = Mid(ean128, 27, 8)
'remise en forme dluo
JOUR = Mid(ean128, 23, 2)
mois = Mid(ean128, 21, 2)
annee = Mid(ean128, 19, 2)
dluo = JOUR & "/" & mois & "/" & annee
Q = Mid(ean128, 37, 4) ' Quantité
Call cherche
End If
' valide le sscc apres harrissa
If miseajour = True And sscclog.Visible = False Then ' The ENTER key.
' palette complete ! ! ! !
Call ecrit
ean128.SetFocus
ean128 = ""
SSCC = ""
Harissa.renseigne = False
miseajour = False
ean128.SetFocus
End If
' palette INcomlete ! ! ! !
If miseajour = True And sscclog.Visible = True Then ' The ENTER key.
Call affinputbox
End If
End Sub
Private Sub affinputbox()
Qt3 = InputBox("Nombre d'UVC", "Saisie quantité")
Q = Qt3
Call ecrit
ean128.SetFocus
ean128 = ""
SSCC = ""
Harissa.renseigne = False
miseajour = False
ean128.SetFocus
End Sub |