Private Sub AskPin_Click() 3740 On Error GoTo AskPin_Click_Error 3750 If Len(Userid) < 6 Then 3760 MsgBox ("Le nom d'utilisateur doit comporter au moins 6 caractères"), vbExclamation 3770 Exit Sub 3780 End If ... 4910 Instr1.Visible = True 4920 Instr3.Visible = False 4930 End If 4940 On Error GoTo 0 4950 Exit Sub AskPin_Click_Error: 4960 ErrHdl ("AskPin_Click dans Connexion") End Sub
On Error Goto 0car le gestionnaire d'erreurs est automatiquement désactivé en sortant de la Sub
Private Sub Help_Click() On Error GoTo Help_Click_Error ... On Error GoTo 0 Exit Sub Help_Click_Error: ErrHdl ("Help_Click dans Angles") End Sub
Private Sub Drawgraph() 30170 On Error GoTo Drawgraph_Error ... 30990 Graph.Line (Val(KH) + GardeX, Graph.ScaleHeight - GardeY)-(Val(KH) + GardeX, GardeY), vbYellowKH = "-1000000000" : pourquoi erreur 0 et pas overflow ?
Dim A as Integer = Val("120") ' retourne un Integer Dim B as Long = Val("120") ' retourne la même valeur mais de type Long
Val(KH)
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionPrivate Sub AskPin_Click() 3740 On Error GoTo AskPin_Click_Error ... 4610 On Error Resume Next 4620 ObjSendMail.Send ... 4940 On Error GoTo 0 4950 Exit Sub AskPin_Click_Error: 4960 ErrHdl ("AskPin_Click dans Connexion") End Sub
On Error Goto 0
Private Sub AskPin_Click() 3740 On Error GoTo AskPin_Click_Error ... 4620 SendMail() ' sub pour envoi mail ... 4950 Exit Sub AskPin_Click_Error: 4960 ErrHdl ("AskPin_Click dans Connexion") End Sub Private Sub SendMail() On Error ResumeNext ObjSendMail.Send
if Fichier = "" then ' gère erreur nom de fichier inexistant ' Message d'erreur Exit sub End if ' on lit le fichier ici
Le temps que je convertisse il sera obsolète !
Public Function GetKeyDataValue(KeyValueName As String) As String Dim OpenKey As Long, hKey As Long, strTempVal As String, KeyValSize As Long, lngI As Long Dim RegKeyROOT As Long Dim KeyDataType As Long Dim RegKeyName As String 25660 On Error GoTo GetKeyDataValue_Error 25670 RegKeyROOT = HKEY_CURRENT_USER 25680 KeyDataType = 1 'REG_SZ = 1 25690 RegKeyName = "SOFTWARE\RVReefTools" 25700 OpenKey = RegOpenKeyEx(RegKeyROOT, RegKeyName, 0, KEY_ALL_ACCESS, hKey) 25710 If (OpenKey = 0) Then 25720 strTempVal = String$(1024, 0) 25730 KeyValSize = 1024 25740 OpenKey = RegQueryValueEx(hKey, KeyValueName, 0, KeyDateType, strTempVal, KeyValSize) 25750 If (Asc(Mid(strTempVal, KeyValSize, 1)) = 0) Then 25760 GetKeyDataValue = Left(strTempVal, KeyValSize - 1) 25770 Else 25780 GetKeyDataValue = Left(strTempVal, KeyValSize) 25790 End If 25800 OpenKey = RegCloseKey(hKey) 25810 Else 25820 GetKeyDataValue = "" 25830 End If 25840 On Error GoTo 0 25850 Exit Function GetKeyDataValue_Error: 25860 ErrHdl ("GetKeyDataValue dans Registry") End Function
Function LastValue(ByVal i) As Single 57630 On Error GoTo LastValue_Error 57640 LastValue = EmptyData 57650 If TabLast > 0 Then 57660 If DataStyle(0) Then K = DataRaw Else K = DataAdj 57670 For j = Records.ListIndex + 1 To Records.ListCount 57680 If HistoData(i, K, j) <> EmptyData Then LastValue = Abs(HistoData(i, K, j)): Exit For 57690 Next j 57700 End If 57710 On Error GoTo 0 57720 Exit Function LastValue_Error: 57730 ErrHdl ("LastValue dans LogBook : ListCount=" & Str$(Records.ListCount) & " i=" & Str$(i) & " j=" & Str$(j) & " k=" & Str$(K)) End Function