IdentifiantMot de passe
Loading...
Mot de passe oublié ?Je m'inscris ! (gratuit)
Navigation

Inscrivez-vous gratuitement
pour pouvoir participer, suivre les réponses en temps réel, voter pour les messages, poser vos propres questions et recevoir la newsletter

VB.NET Discussion :

Problème saisie d'un champ


Sujet :

VB.NET

Vue hybride

Message précédent Message précédent   Message suivant Message suivant
  1. #1
    Membre confirmé
    Inscrit en
    Mai 2007
    Messages
    257
    Détails du profil
    Informations forums :
    Inscription : Mai 2007
    Messages : 257
    Par défaut Problème saisie d'un champ
    J'ai un pb lorsque j'essaye de saisir le champ "Montant de l'avance", il me sort le msg suivant "La conversion de la chaîne " " en type 'Décimal' n'est pas valide".
    Voici mon code :
    Code : Sélectionner tout - Visualiser dans une fenêtre à part
    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
    92
    93
    94
    95
    96
    97
    98
    99
    100
    101
    102
    103
    104
    105
    106
    107
    108
    109
    110
    111
    112
    113
    114
    115
    116
    117
    118
    119
    120
    121
    122
    123
    124
    125
    126
    127
    128
    129
    130
    131
    132
    133
    134
    135
    136
    137
    138
    139
    140
    141
    142
    143
    144
    145
    146
    147
    148
    149
    150
    151
    152
    153
    154
    155
    156
    157
    158
    159
    160
    161
    162
    163
    164
    165
    166
    167
    168
    169
    170
    171
    172
    173
    174
    175
    176
    177
     
     Private Sub Txtmontantavance_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Txtmontantavance.TextChanged
            If Enannulation = True Then Exit Sub
            Txtmontantavance.Text = Txtmontantavance.Text.Replace(".", ",")
            Txtmontantavance.Select(Txtmontantavance.Text.Length, 0)
            If Txtmontantavance.Text = "" Then
                Txtmontantavance.Text = ""
                Dim z As [Decimal] = CDec(Txtmontantc.Text)
                Dim w As [Decimal] = CDec(Txtrea1ertrim.Text)
                Dim p As [Decimal] = CDec(Txtre2emetrim.Text)
                Dim o As [Decimal] = CDec(Txtrea3emetrim.Text)
                Dim m As [Decimal] = CDec(Txtrea4emetrim.Text)
                Txttotalrea.Text = CDec(w) + CDec(p) + CDec(o) + CDec(m)
                Txtmontantpaye.Text = CDec(w) + CDec(p) + CDec(o) + CDec(m)
                Txtresteapayer.Text = CDec(z) - (CDec(w) + CDec(p) + CDec(o) + CDec(m))
            ElseIf Txtrea1ertrim.Text = "" Then
                Dim r As [Decimal] = CDec(Txtmontantc.Text)
                Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                'Dim a As [Decimal] = CDec(Txtrea1ertrim.Text)
                Dim b As [Decimal] = CDec(Txtre2emetrim.Text)
                Dim c As [Decimal] = CDec(Txtrea3emetrim.Text)
                Dim d As [Decimal] = CDec(Txtrea4emetrim.Text)
                Txttotalrea.Text = CDec(b) + CDec(c) + CDec(d) + CDec(resul)
                Txtmontantpaye.Text = CDec(b) + CDec(c) + CDec(d) + CDec(resul)
                Txtresteapayer.Text = CDec(r) - (CDec(b) + CDec(c) + CDec(d) + CDec(resul))
            ElseIf Txtre2emetrim.Text = "" Then
                Dim r As [Decimal] = CDec(Txtmontantc.Text)
                Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                Dim a As [Decimal] = CDec(Txtrea1ertrim.Text)
                'Dim b As [Decimal] = CDec(Txtre2emetrim.Text)
                Dim c As [Decimal] = CDec(Txtrea3emetrim.Text)
                Dim d As [Decimal] = CDec(Txtrea4emetrim.Text)
                Txttotalrea.Text = CDec(a) + CDec(c) + CDec(d) + CDec(resul)
                Txtmontantpaye.Text = CDec(a) + CDec(c) + CDec(d) + CDec(resul)
                Txtresteapayer.Text = CDec(r) - (CDec(a) + CDec(c) + CDec(d) + CDec(resul))
            ElseIf Txtrea3emetrim.Text = "" Then
                Dim r As [Decimal] = CDec(Txtmontantc.Text)
                Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                Dim a As [Decimal] = CDec(Txtrea1ertrim.Text)
                Dim b As [Decimal] = CDec(Txtre2emetrim.Text)
                'Dim c As [Decimal] = CDec(Txtrea3emetrim.Text)
                Dim d As [Decimal] = CDec(Txtrea4emetrim.Text)
                Txttotalrea.Text = CDec(a) + CDec(b) + CDec(d) + CDec(resul)
                Txtmontantpaye.Text = CDec(a) + CDec(b) + CDec(d) + CDec(resul)
                Txtresteapayer.Text = CDec(r) - (CDec(a) + CDec(b) + CDec(d) + CDec(resul))
            ElseIf Txtrea4emetrim.Text = "" Then
                Dim r As [Decimal] = CDec(Txtmontantc.Text)
                Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                Dim a As [Decimal] = CDec(Txtrea1ertrim.Text)
                Dim b As [Decimal] = CDec(Txtre2emetrim.Text)
                Dim c As [Decimal] = CDec(Txtrea3emetrim.Text)
                'Dim d As [Decimal] = CDec(Txtrea4emetrim.Text)
                Txttotalrea.Text = CDec(a) + CDec(b) + CDec(c) + CDec(resul)
                Txtmontantpaye.Text = CDec(a) + CDec(b) + CDec(c) + CDec(resul)
                Txtresteapayer.Text = CDec(r) - (CDec(a) + CDec(b) + CDec(c) + CDec(resul))
            ElseIf Txtrea1ertrim.Text = "" And Txtre2emetrim.Text = "" Then
                Dim r As [Decimal] = CDec(Txtmontantc.Text)
                Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                'Dim a As [Decimal] = CDec(Txtrea1ertrim.Text)
                'Dim b As [Decimal] = CDec(Txtre2emetrim.Text)
                Dim c As [Decimal] = CDec(Txtrea3emetrim.Text)
                Dim d As [Decimal] = CDec(Txtrea4emetrim.Text)
                Txttotalrea.Text = CDec(d) + CDec(c) + CDec(resul)
                Txtmontantpaye.Text = CDec(d) + CDec(c) + CDec(resul)
                Txtresteapayer.Text = CDec(r) - (CDec(d) + CDec(c) + CDec(resul))
            ElseIf Txtre2emetrim.Text = "" And Txtrea3emetrim.Text = "" Then
                Dim r As [Decimal] = CDec(Txtmontantc.Text)
                Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                Dim a As [Decimal] = CDec(Txtrea1ertrim.Text)
                'Dim b As [Decimal] = CDec(Txtre2emetrim.Text)
                'Dim c As [Decimal] = CDec(Txtrea3emetrim.Text)
                Dim d As [Decimal] = CDec(Txtrea4emetrim.Text)
                Txttotalrea.Text = CDec(d) + CDec(a) + CDec(resul)
                Txtmontantpaye.Text = CDec(d) + CDec(a) + CDec(resul)
                Txtresteapayer.Text = CDec(r) - (CDec(d) + CDec(a) + CDec(resul))
            ElseIf Txtre2emetrim.Text = "" And Txtrea4emetrim.Text = "" And Txtrea4emetrim.Text = "" Then
                Dim r As [Decimal] = CDec(Txtmontantc.Text)
                Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                Dim a As [Decimal] = CDec(Txtrea1ertrim.Text)
                'Dim b As [Decimal] = CDec(Txtre2emetrim.Text)
                Dim c As [Decimal] = CDec(Txtrea3emetrim.Text)
                'Dim d As [Decimal] = CDec(Txtrea4emetrim.Text)
                Txttotalrea.Text = CDec(a) + CDec(c) + CDec(resul)
                Txtmontantpaye.Text = CDec(a) + CDec(c) + CDec(resul)
                Txtresteapayer.Text = CDec(r) - (CDec(a) + CDec(c) + CDec(resul))
            ElseIf Txtrea1ertrim.Text = "" And Txtrea3emetrim.Text = "" Then
                Dim r As [Decimal] = CDec(Txtmontantc.Text)
                Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                'Dim a As [Decimal] = CDec(Txtrea1ertrim.Text)
                Dim b As [Decimal] = CDec(Txtre2emetrim.Text)
                'Dim c As [Decimal] = CDec(Txtrea3emetrim.Text)
                Dim d As [Decimal] = CDec(Txtrea4emetrim.Text)
                Txttotalrea.Text = CDec(b) + CDec(d) + CDec(resul)
                Txtmontantpaye.Text = CDec(b) + CDec(d) + CDec(resul)
                Txtresteapayer.Text = CDec(r) - (CDec(b) + CDec(d) + CDec(resul))
            ElseIf Txtrea1ertrim.Text = "" And Txtrea4emetrim.Text = "" Then
                Dim r As [Decimal] = CDec(Txtmontantc.Text)
                Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                'Dim a As [Decimal] = CDec(Txtrea1ertrim.Text)
                Dim b As [Decimal] = CDec(Txtre2emetrim.Text)
                Dim c As [Decimal] = CDec(Txtrea3emetrim.Text)
                'Dim d As [Decimal] = CDec(Txtrea4emetrim.Text)
                Txttotalrea.Text = CDec(b) + CDec(c) + CDec(resul)
                Txtmontantpaye.Text = CDec(b) + CDec(c) + CDec(resul)
                Txtresteapayer.Text = CDec(r) - (CDec(b) + CDec(c) + CDec(resul))
            ElseIf Txtrea3emetrim.Text = "" And Txtrea4emetrim.Text = "" Then
                Dim r As [Decimal] = CDec(Txtmontantc.Text)
                Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                Dim a As [Decimal] = CDec(Txtrea1ertrim.Text)
                Dim b As [Decimal] = CDec(Txtre2emetrim.Text)
                'Dim c As [Decimal] = CDec(Txtrea3emetrim.Text)
                'Dim d As [Decimal] = CDec(Txtrea4emetrim.Text)
                Txttotalrea.Text = CDec(b) + CDec(a) + CDec(resul)
                Txtmontantpaye.Text = CDec(b) + CDec(a) + CDec(resul)
                Txtresteapayer.Text = CDec(r) - (CDec(b) + CDec(a) + CDec(resul))
            ElseIf Txtrea1ertrim.Text = "" And Txtrea3emetrim.Text = "" And Txtrea4emetrim.Text = "" Then
                Dim r As [Decimal] = CDec(Txtmontantc.Text)
                Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                'Dim a As [Decimal] = CDec(Txtrea1ertrim.Text)
                Dim b As [Decimal] = CDec(Txtre2emetrim.Text)
                'Dim c As [Decimal] = CDec(Txtrea3emetrim.Text)
                'Dim d As [Decimal] = CDec(Txtrea4emetrim.Text)
                Txttotalrea.Text = CDec(b) + CDec(resul)
                Txtmontantpaye.Text = CDec(b) + CDec(resul)
                Txtresteapayer.Text = CDec(r) - (CDec(b) + CDec(resul))
            ElseIf Txtrea1ertrim.Text = "" And Txtre2emetrim.Text = "" And Txtrea4emetrim.Text = "" Then
                Dim r As [Decimal] = CDec(Txtmontantc.Text)
                Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                'Dim a As [Decimal] = CDec(Txtrea1ertrim.Text)
                'Dim b As [Decimal] = CDec(Txtre2emetrim.Text)
                Dim c As [Decimal] = CDec(Txtrea3emetrim.Text)
                'Dim d As [Decimal] = CDec(Txtrea4emetrim.Text)
                Txttotalrea.Text = CDec(c) + CDec(resul)
                Txtmontantpaye.Text = CDec(c) + CDec(resul)
                Txtresteapayer.Text = CDec(r) - (CDec(c) + CDec(resul))
            ElseIf Txtre2emetrim.Text = "" And Txtrea3emetrim.Text = "" And Txtrea4emetrim.Text = "" Then
                Dim r As [Decimal] = CDec(Txtmontantc.Text)
                Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                Dim a As [Decimal] = CDec(Txtrea1ertrim.Text)
                'Dim b As [Decimal] = CDec(Txtre2emetrim.Text)
                'Dim c As [Decimal] = CDec(Txtrea3emetrim.Text)
                'Dim d As [Decimal] = CDec(Txtrea4emetrim.Text)
                Txttotalrea.Text = CDec(a) + CDec(resul)
                Txtmontantpaye.Text = CDec(a) + CDec(resul)
                Txtresteapayer.Text = CDec(r) - (CDec(a) + CDec(resul))
            ElseIf Txtrea1ertrim.Text = "" And Txtre2emetrim.Text = "" And Txtrea3emetrim.Text = "" Then
                Dim r As [Decimal] = CDec(Txtmontantc.Text)
                Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                'Dim a As [Decimal] = CDec(Txtrea1ertrim.Text)
                'Dim b As [Decimal] = CDec(Txtre2emetrim.Text)
                'Dim c As [Decimal] = CDec(Txtrea3emetrim.Text)
                Dim d As [Decimal] = CDec(Txtrea4emetrim.Text)
                Txttotalrea.Text = CDec(d) + CDec(resul)
                Txtmontantpaye.Text = CDec(d) + CDec(resul)
                Txtresteapayer.Text = CDec(r) - (CDec(d) + CDec(resul))
            ElseIf Txtrea1ertrim.Text = "" And Txtre2emetrim.Text = "" And Txtrea3emetrim.Text = "" And Txtrea4emetrim.Text = "" Then
                Dim r As [Decimal] = CDec(Txtmontantc.Text)
                Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                'Dim a As [Decimal] = CDec(Txtrea1ertrim.Text)
                'Dim b As [Decimal] = CDec(Txtre2emetrim.Text)
                'Dim c As [Decimal] = CDec(Txtrea3emetrim.Text)
                'Dim d As [Decimal] = CDec(Txtrea4emetrim.Text)
                Txttotalrea.Text = CDec(resul)
                Txtmontantpaye.Text = CDec(resul)
                Txtresteapayer.Text = CDec(r) - CDec(resul)
            ElseIf Txtrea1ertrim.Text = "" Then
                Dim r As [Decimal] = CDec(Txtmontantc.Text)
                Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                Dim a As [Decimal] = CDec(Txtrea1ertrim.Text)
                'Dim b As [Decimal] = CDec(Txtre2emetrim.Text)
                'Dim c As [Decimal] = CDec(Txtrea3emetrim.Text)
                'Dim d As [Decimal] = CDec(Txtrea4emetrim.Text)
                Txttotalrea.Text = CDec(a) + CDec(resul)
                Txtmontantpaye.Text = CDec(a) + CDec(resul)
                Txtresteapayer.Text = CDec(r) - (CDec(a) + CDec(resul))
            End If
        End Sub
    Le msg d'erreur s'affiche au niveau de cette ligne de code :
    Code : Sélectionner tout - Visualiser dans une fenêtre à part
    1
    2
    3
     
    ElseIf Txtre2emetrim.Text = "" Then
              Dim c As [Decimal] = CDec(Txtrea3emetrim.Text)
    C'est due à quoi?

  2. #2
    Membre éclairé
    Inscrit en
    Mars 2006
    Messages
    342
    Détails du profil
    Informations forums :
    Inscription : Mars 2006
    Messages : 342
    Par défaut
    Bah je comprend pas ta question. C due au fait qu il n y a rien dans ta textbox et que t essayes d appliquer CDec a ... rien.

    Arf, encore trompé un coup t as 2 et un coup 3 sorry ...

  3. #3
    Membre confirmé
    Inscrit en
    Mai 2007
    Messages
    257
    Détails du profil
    Informations forums :
    Inscription : Mai 2007
    Messages : 257
    Par défaut
    Le champ vide c'est "txtre2emetrim" et le champ rempli c'est "txtrea3emetrim"

  4. #4
    Membre éclairé
    Inscrit en
    Mars 2006
    Messages
    342
    Détails du profil
    Informations forums :
    Inscription : Mars 2006
    Messages : 342
    Par défaut
    est ce que t sur qu il y a un truc dans la 3 ?

  5. #5
    Membre confirmé
    Inscrit en
    Mai 2007
    Messages
    257
    Détails du profil
    Informations forums :
    Inscription : Mai 2007
    Messages : 257
    Par défaut
    J'explique la situation: J'ai 5 champs "txtrea1ertrim", "txtre2emetrim", "txtrea3emetrim", "txtrea4emetrim" et "txtmontantavance". Les 4 1er champs peuvent être remplis ou vides ou quelques uns remplis et d'autres vides. Je veux que lorsque j'essaye de remplir le champ "txtmontantavance" il ne m'affiche pas cette erreur comme indiqué ci-dessous.

  6. #6
    Membre confirmé
    Inscrit en
    Mai 2007
    Messages
    257
    Détails du profil
    Informations forums :
    Inscription : Mai 2007
    Messages : 257
    Par défaut
    J'ai essayé ceci mais ca ne marche tjrs pas :
    Code : Sélectionner tout - Visualiser dans une fenêtre à part
    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
    92
    93
    94
    95
    96
    97
    98
    99
    100
    101
    102
    103
    104
    105
    106
    107
    108
    109
    110
    111
    112
    113
    114
    115
    116
    117
    118
    119
    120
    121
    122
    123
    124
    125
    126
    127
    128
    129
    130
    131
    132
    133
    134
    135
    136
    137
    138
    139
    140
    141
    142
    143
    144
    145
    146
    147
    148
    149
    150
    151
    152
    153
     
    Private Sub Txtmontantavance_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Txtmontantavance.TextChanged
     
            Try
                If Enannulation = True Then Exit Sub
                Txtmontantavance.Text = Txtmontantavance.Text.Replace(".", ",")
                Txtmontantavance.Select(Txtmontantavance.Text.Length, 0)
                If Txtmontantavance.Text = "" Then
                    Txtmontantavance.Text = ""
                    Dim z As [Decimal] = CDec(Txtmontantc.Text)
                    Dim w As [Decimal] = CDec(Txtrea1ertrim.Text)
                    Dim p As [Decimal] = CDec(Txtre2emetrim.Text)
                    Dim o As [Decimal] = CDec(Txtrea3emetrim.Text)
                    Dim m As [Decimal] = CDec(Txtrea4emetrim.Text)
                    Txttotalrea.Text = CDec(w) + CDec(p) + CDec(o) + CDec(m)
                    Txtmontantpaye.Text = CDec(w) + CDec(p) + CDec(o) + CDec(m)
                    Txtresteapayer.Text = CDec(z) - (CDec(w) + CDec(p) + CDec(o) + CDec(m))
                End If
                If Txtmontantavance.Text <> "" Then
                    If Txtrea1ertrim.Text = "" Then
                        Dim r As [Decimal] = CDec(Txtmontantc.Text)
                        Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                        Dim b As [Decimal] = CDec(Txtre2emetrim.Text)
                        Dim c As [Decimal] = CDec(Txtrea3emetrim.Text)
                        Dim d As [Decimal] = CDec(Txtrea4emetrim.Text)
                        Txttotalrea.Text = CDec(b) + CDec(c) + CDec(d) + CDec(resul)
                        Txtmontantpaye.Text = CDec(b) + CDec(c) + CDec(d) + CDec(resul)
                        Txtresteapayer.Text = CDec(r) - (CDec(b) + CDec(c) + CDec(d) + CDec(resul))
                    ElseIf Txtre2emetrim.Text = "" Then
                        Dim r As [Decimal] = CDec(Txtmontantc.Text)
                        Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                        Dim a As [Decimal] = CDec(Txtrea1ertrim.Text)
                        Dim c As [Decimal] = CDec(Txtrea3emetrim.Text)
                        Dim d As [Decimal] = CDec(Txtrea4emetrim.Text)
                        Txttotalrea.Text = CDec(a) + CDec(c) + CDec(d) + CDec(resul)
                        Txtmontantpaye.Text = CDec(a) + CDec(c) + CDec(d) + CDec(resul)
                        Txtresteapayer.Text = CDec(r) - (CDec(a) + CDec(c) + CDec(d) + CDec(resul))
                    ElseIf Txtrea3emetrim.Text = "" Then
                        Dim r As [Decimal] = CDec(Txtmontantc.Text)
                        Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                        Dim a As [Decimal] = CDec(Txtrea1ertrim.Text)
                        Dim b As [Decimal] = CDec(Txtre2emetrim.Text)
                        Dim d As [Decimal] = CDec(Txtrea4emetrim.Text)
                        Txttotalrea.Text = CDec(a) + CDec(b) + CDec(d) + CDec(resul)
                        Txtmontantpaye.Text = CDec(a) + CDec(b) + CDec(d) + CDec(resul)
                        Txtresteapayer.Text = CDec(r) - (CDec(a) + CDec(b) + CDec(d) + CDec(resul))
                    ElseIf Txtrea4emetrim.Text = "" Then
                        Dim r As [Decimal] = CDec(Txtmontantc.Text)
                        Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                        Dim a As [Decimal] = CDec(Txtrea1ertrim.Text)
                        Dim b As [Decimal] = CDec(Txtre2emetrim.Text)
                        Dim c As [Decimal] = CDec(Txtrea3emetrim.Text)
                        Txttotalrea.Text = CDec(a) + CDec(b) + CDec(c) + CDec(resul)
                        Txtmontantpaye.Text = CDec(a) + CDec(b) + CDec(c) + CDec(resul)
                        Txtresteapayer.Text = CDec(r) - (CDec(a) + CDec(b) + CDec(c) + CDec(resul))
                    ElseIf Txtrea1ertrim.Text = "" And Txtre2emetrim.Text = "" Then
                        Dim r As [Decimal] = CDec(Txtmontantc.Text)
                        Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                        Dim c As [Decimal] = CDec(Txtrea3emetrim.Text)
                        Dim d As [Decimal] = CDec(Txtrea4emetrim.Text)
                        Txttotalrea.Text = CDec(d) + CDec(c) + CDec(resul)
                        Txtmontantpaye.Text = CDec(d) + CDec(c) + CDec(resul)
                        Txtresteapayer.Text = CDec(r) - (CDec(d) + CDec(c) + CDec(resul))
                    ElseIf Txtre2emetrim.Text = "" And Txtrea3emetrim.Text = "" Then
                        Dim r As [Decimal] = CDec(Txtmontantc.Text)
                        Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                        Dim a As [Decimal] = CDec(Txtrea1ertrim.Text)
                        Dim d As [Decimal] = CDec(Txtrea4emetrim.Text)
                        Txttotalrea.Text = CDec(d) + CDec(a) + CDec(resul)
                        Txtmontantpaye.Text = CDec(d) + CDec(a) + CDec(resul)
                        Txtresteapayer.Text = CDec(r) - (CDec(d) + CDec(a) + CDec(resul))
                    ElseIf Txtre2emetrim.Text = "" And Txtrea4emetrim.Text = "" And Txtrea4emetrim.Text = "" Then
                        Dim r As [Decimal] = CDec(Txtmontantc.Text)
                        Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                        Dim a As [Decimal] = CDec(Txtrea1ertrim.Text)
                        Dim c As [Decimal] = CDec(Txtrea3emetrim.Text)
                        Txttotalrea.Text = CDec(a) + CDec(c) + CDec(resul)
                        Txtmontantpaye.Text = CDec(a) + CDec(c) + CDec(resul)
                        Txtresteapayer.Text = CDec(r) - (CDec(a) + CDec(c) + CDec(resul))
                    ElseIf Txtrea1ertrim.Text = "" And Txtrea3emetrim.Text = "" Then
                        Dim r As [Decimal] = CDec(Txtmontantc.Text)
                        Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                        Dim b As [Decimal] = CDec(Txtre2emetrim.Text)
                        Dim d As [Decimal] = CDec(Txtrea4emetrim.Text)
                        Txttotalrea.Text = CDec(b) + CDec(d) + CDec(resul)
                        Txtmontantpaye.Text = CDec(b) + CDec(d) + CDec(resul)
                        Txtresteapayer.Text = CDec(r) - (CDec(b) + CDec(d) + CDec(resul))
                    ElseIf Txtrea1ertrim.Text = "" And Txtrea4emetrim.Text = "" Then
                        Dim r As [Decimal] = CDec(Txtmontantc.Text)
                        Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                        Dim b As [Decimal] = CDec(Txtre2emetrim.Text)
                        Dim c As [Decimal] = CDec(Txtrea3emetrim.Text)
                        Txttotalrea.Text = CDec(b) + CDec(c) + CDec(resul)
                        Txtmontantpaye.Text = CDec(b) + CDec(c) + CDec(resul)
                        Txtresteapayer.Text = CDec(r) - (CDec(b) + CDec(c) + CDec(resul))
                    ElseIf Txtrea3emetrim.Text = "" And Txtrea4emetrim.Text = "" Then
                        Dim r As [Decimal] = CDec(Txtmontantc.Text)
                        Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                        Dim a As [Decimal] = CDec(Txtrea1ertrim.Text)
                        Dim b As [Decimal] = CDec(Txtre2emetrim.Text)
                        Txttotalrea.Text = CDec(b) + CDec(a) + CDec(resul)
                        Txtmontantpaye.Text = CDec(b) + CDec(a) + CDec(resul)
                        Txtresteapayer.Text = CDec(r) - (CDec(b) + CDec(a) + CDec(resul))
                    ElseIf Txtrea1ertrim.Text = "" And Txtrea3emetrim.Text = "" And Txtrea4emetrim.Text = "" Then
                        Dim r As [Decimal] = CDec(Txtmontantc.Text)
                        Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                        Dim b As [Decimal] = CDec(Txtre2emetrim.Text)
                        Txttotalrea.Text = CDec(b) + CDec(resul)
                        Txtmontantpaye.Text = CDec(b) + CDec(resul)
                        Txtresteapayer.Text = CDec(r) - (CDec(b) + CDec(resul))
                    ElseIf Txtrea1ertrim.Text = "" And Txtre2emetrim.Text = "" And Txtrea4emetrim.Text = "" Then
                        Dim r As [Decimal] = CDec(Txtmontantc.Text)
                        Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                        Dim c As [Decimal] = CDec(Txtrea3emetrim.Text)
                        Txttotalrea.Text = CDec(c) + CDec(resul)
                        Txtmontantpaye.Text = CDec(c) + CDec(resul)
                        Txtresteapayer.Text = CDec(r) - (CDec(c) + CDec(resul))
                    ElseIf Txtre2emetrim.Text = "" And Txtrea3emetrim.Text = "" And Txtrea4emetrim.Text = "" Then
                        Dim r As [Decimal] = CDec(Txtmontantc.Text)
                        Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                        Dim a As [Decimal] = CDec(Txtrea1ertrim.Text)
                        Txttotalrea.Text = CDec(a) + CDec(resul)
                        Txtmontantpaye.Text = CDec(a) + CDec(resul)
                        Txtresteapayer.Text = CDec(r) - (CDec(a) + CDec(resul))
                    ElseIf Txtrea1ertrim.Text = "" And Txtre2emetrim.Text = "" And Txtrea3emetrim.Text = "" Then
                        Dim r As [Decimal] = CDec(Txtmontantc.Text)
                        Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                        Dim d As [Decimal] = CDec(Txtrea4emetrim.Text)
                        Txttotalrea.Text = CDec(d) + CDec(resul)
                        Txtmontantpaye.Text = CDec(d) + CDec(resul)
                        Txtresteapayer.Text = CDec(r) - (CDec(d) + CDec(resul))
                    ElseIf Txtrea1ertrim.Text = "" And Txtre2emetrim.Text = "" And Txtrea3emetrim.Text = "" And Txtrea4emetrim.Text = "" Then
                        Dim r As [Decimal] = CDec(Txtmontantc.Text)
                        Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                        Txttotalrea.Text = CDec(resul)
                        Txtmontantpaye.Text = CDec(resul)
                        Txtresteapayer.Text = CDec(r) - CDec(resul)
                    ElseIf Txtrea1ertrim.Text = "" Then
                        Dim r As [Decimal] = CDec(Txtmontantc.Text)
                        Dim resul As [Decimal] = CDec(Txtmontantavance.Text)
                        Dim a As [Decimal] = CDec(Txtrea1ertrim.Text)
                        Txttotalrea.Text = CDec(a) + CDec(resul)
                        Txtmontantpaye.Text = CDec(a) + CDec(resul)
                        Txtresteapayer.Text = CDec(r) - (CDec(a) + CDec(resul))
                    End If
                End If
            Catch ex As Exception
                'MsgBox("Vous devez saisir une valeur monétaire")
                'Txtmontantavance.Text = ""
                'Txtmontantavance.Focus()
                MsgBox(ex.Message)
            End Try
        End Sub
    Que faire? SVP aidez moi

  7. #7
    Expert éminent Avatar de Pol63
    Homme Profil pro
    .NET / SQL SERVER
    Inscrit en
    Avril 2007
    Messages
    14 197
    Détails du profil
    Informations personnelles :
    Sexe : Homme
    Âge : 43
    Localisation : France, Puy de Dôme (Auvergne)

    Informations professionnelles :
    Activité : .NET / SQL SERVER

    Informations forums :
    Inscription : Avril 2007
    Messages : 14 197
    Par défaut
    un cdec ne marche que si la chaine contient un nombre
    " " n'est pas un nombre
    donc tu try
    valeur = cdec(chaine)
    catch
    valeur = 0
    end try
    et valeur est bien un nombre que tu peux mettre dans ton champ
    Cours complets, tutos et autres FAQ ici : C# - VB.NET

+ Répondre à la discussion
Cette discussion est résolue.

Discussions similaires

  1. [AC-2010] Problème de saisie dans un champ
    Par DevilTom dans le forum VBA Access
    Réponses: 10
    Dernier message: 20/04/2012, 11h15
  2. Problème de saisie dans un champs alpha
    Par mourad_55 dans le forum 4D
    Réponses: 7
    Dernier message: 11/01/2012, 13h27
  3. [AC-2010] Problème saisie champs pour requête
    Par Julianinho dans le forum Modélisation
    Réponses: 5
    Dernier message: 21/07/2011, 13h33
  4. Réponses: 4
    Dernier message: 20/04/2007, 17h07
  5. [MySQL] Problème avec la saisie d'un champ
    Par zoom61 dans le forum PHP & Base de données
    Réponses: 2
    Dernier message: 24/08/2006, 13h49

Partager

Partager
  • Envoyer la discussion sur Viadeo
  • Envoyer la discussion sur Twitter
  • Envoyer la discussion sur Google
  • Envoyer la discussion sur Facebook
  • Envoyer la discussion sur Digg
  • Envoyer la discussion sur Delicious
  • Envoyer la discussion sur MySpace
  • Envoyer la discussion sur Yahoo