Overflow error in access databse handling

[pensnaku]

hi every one. pls i am recieving this overflow error when i try to insert values into an access database. its really freaking me out. i have tried several approaches but to no avail. i would be very grateful if anyone can help me through this. here is my code below:

       admisnNumber = Val(TxtAdNumber.Text)
        childnames = Trim(TxtboxName.Text)
        fadazName = Trim(TxtboxFadasName.Text)
        fadazphoneNo = Val(TxtboxFatherContact.Text)
        modazname = Trim(TxtboxMothersName.Text)
        modazphoneNo = Val(TxtboxMothersContact.Text)
        EM1 = Val(txtboxEMcontact1.Text)
        healthstate = txtboxHealth.Text
        DOB = DOBPicker.Value
 
        Dim cmd As New OleDbCommand
        If Not link.State = ConnectionState.Open Then
            link.Open()
        End If
        cmd.Connection = link
        cmd.CommandText = "INSERT INTO Children([StudentID], [Name], [DOB], [Sex], [Health], [Address] , [ParentID]) " & _
                        " VALUES(' " & admisnNumber & " ','" & childnames & "','" & DOB & "','" & sex & "','" & healthstate & "','" & address & "','" & admisnNumber & " ') "
        cmd.ExecuteNonQuery()
        Dim cmd2 As New OleDbCommand
        cmd2.CommandText = "INSERT INTO Parents( [NameFather], [NameMother], [ContactMother], [ContactFather], [ContactEmergency]) " & _
            " VALUES ('" & fadazName & "','" & modazname & "','" & CLng(modazphoneNo) & "','" & CLng(fadazphoneNo) & "','" & CLng(EM1) & "' )"
        cmd2.Connection = link
        cmd2.ExecuteNonQuery()' THE ERROR USUALLY APPEARS HERE
        link.Close()
        MsgBox("STUDENT DATA SUCCESSFUL ADDED TO DATABASE!")

[jimatqsi]

pensnaku,
Welcome to bytes. As with most new posters it would be great if you would review the information here and apply it http://bytes.com/faq.php . Most importantly, use code tags. It freaks people out to see posts without code tags.

As for your problem, do the obvious. You're outputting a number of Long integers. Is the table defined appropriately? Are you putting longs into singles?

Get creative. Run the query manually as a select query. Review the data - does it look right? Remove individual columns from the output and try again until the problem doesn't happen. Then you've identified the column causing the problem.

Think! Get creative.

Jim

[zmbd]

---
By, simply stating that your code "doesn't work," along with posting code that appears to have had very little if any troubleshooting performed, and expecting someone to help doesn't usually result in much of an answer and may result in your thread being deleted. Instead, please tell us what you were expecting to happen, what actually happened.

For any errors: for each error; the EXACT title, error number, and descriptions that occurred and at what line in your posted code the error occurred.

These are the minimum requirements for posting a question of this nature.
---

Another thing you should get used to is declaring your variables (DIM statements) at the beginning of your code not hodgepodge as you go as you are currently... it will make maintaining your code much easier for both yourself and anyone that follows.