Click here to Skip to main content
15,913,396 members

Comments by Member 8005145 (Top 6 by date)

Member 8005145 7-Sep-12 5:01am View    
yahooooo!!!! it works..... thanks again.. thank u very very much for helping the new learners like me.... thank u and thanks to the code project.. :)
Member 8005145 7-Sep-12 5:00am View    
Deleted
yahooooo!!!! it works..... thanks again.. thank u very very much for helping the new learners like me.... thank u and thanks to the code project.. :)
Member 8005145 7-Sep-12 4:38am View    
But sir whenever i am adding string value in consumer contact number field there should be a message or error to show that the field is incorrect,it must be a numeric value.... i wrote the code as
<pre lang="vb">If TextBox4.Text = "" Or TextBox4.Text <> Val(TextBox4.Text) Then

If TextBox4.Text = "" Then
Me.ErrorProvider1.SetError(TextBox4, "Please Enter Contact number")
TextBox4.Focus()
ElseIf TextBox4.Text <> Val(TextBox4.Text) Then
Me.ErrorProvider1.SetError(TextBox4, "Please Enter a valid Contact number ")
TextBox4.Focus()
end if
End if</pre>

it doesnt work... i have created access table in where the consumr_cn data type is number(Long Integer)

the error is in

<pre lang="vb">TextBox4.Text = "" Or TextBox4.Text <> Val(TextBox4.Text)</pre>
suppose the entered data in consumer contact number is abcd.. the error is "Conversion from string "abcd" to type 'Double' is not valid."
i just wanted to check whether the entered value is numeric or not.. is the code wrong for my criteria?
Member 8005145 7-Sep-12 3:25am View    
Thanks sir... :)
Member 8005145 7-Sep-12 3:24am View    
it also works