Error when trying to insert data to access. URGENT.

Copy the query from myinsert to the Access and try to run it from there. You often have a more explicit error message.

Its not a form its a table called YesPledgeForm. Sorry about that.

and what bringing the query into Access?

in access it said microsoft set 1 field(s) to Null due to a type conversion error, and it didnt add 0 records to the table due to key violations, 0 records due to lock violations and 0 records due to validation rule violations.
but here is the wierd thing since the first post i have added some code which includes another variable for the NOW function and another variable to do a check digit on. I am getting the same error as before only in a different place now. Here it is:

If Me.IsPostBack Then
            Dim mydate As String
            Session.Add(mydate, "")
            Session("mydate") = Format(Now(), "yyyyMMdd")
            Session("keyedtotal") = Session("keyedtotal") + txtAmount.Text
            Dim myconnect As OleDbConnection
            Dim mycommand As OleDbCommand
            Dim myinsert As String
            Dim idstring As String
*************error on line below now*****************
            idstring = txtIDNum.Text
***********************************************
            If CheckDigit(idstring, 3, 2) = True Then
                myinsert = "INSERT INTO YesPledgeForm (Amount, MailCode, IDNum, Email, Phone, Yesbox, Occupation, Employer, BatchNum, ResponseDate, DateKeyed) VALUES (" & txtAmount.Text & ", '" & txtMailCode.Text & "', '" & txtID.Text & "', '" & txtEmail.Text & "', '" & txtPhone.Text & "', '" & txtYesBox.Text & "', '" & txtOccupation.Text & "', '" & txtEmployer.Text & "', '" & Session("BatchNum") & "', '" & Session("daterec") & "', '" & Session("mydate") & "')"
                myconnect = New OleDbConnection(Session("constring"))
                myconnect.Open()
                mycommand = New OleDbCommand(myinsert, myconnect)
                mycommand.ExecuteNonQuery()
this is the error again: Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

and here is code from a nearly identical page with just some different fields. and this code works just fine. this is why i am stumped. it seems like there is something going on when i am trying to set a variable to something. i dont know though. i appreciate you help. here is the other code.

If Me.IsPostBack Then
            Dim mydate As String
            Session.Add(mydate, "")
            Session("mydate") = Format(Now(), "yyyyMMdd")
            Session("keyedtotal") = CInt(Session("keyedtotal") + txtAmount.Text)
            Dim myConnect As OleDbConnection
            Dim myCommand As OleDbCommand
            Dim myinsert As String
            'insert the data
            myinsert = "INSERT INTO NoPledgeForm (FName, LName, Apt, Address, City, State, Zip, Amount, Occupation, Employer, Email, BatchNum, ResponseDate, DateKeyed) VALUES ('" & txtFirst.Text & "', '" & txtLast.Text & "', '" & txtApt.Text & "', '" & txtAddress.Text & "', '" & txtCity.Text & "', '" & txtState.Text & "', '" & txtZip.Text & "', " & txtAmount.Text & ", '" & txtOccupation.Text & "', '" & txtEmployer.Text & "', '" & txtEmail.Text & "', '" & Session("BatchNum") & "', '" & Session("daterec") & "', '" & Session("mydate") & "')"
            myConnect = New OleDbConnection(Session("constring"))
            myConnect.Open()
            myCommand = New OleDbCommand(myinsert, myConnect)
            myCommand.ExecuteNonQuery()

one of the field you try to insert contains an invalid value (for example a character value into a numeric field).

Try to remove some of the fields from your statment to find which field is giving you the problem.

but then why would i get that error on the line that says: idstring= txtIDNum.text

what is the error you have?

Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

there is a text box control with that name and it takes 11 characters. it contains an id number of 11 digits for a check digit function to run on. but i cant even get the numbers into the variable. i have no idea why. i keep getting that error.

There is something wrong with this control. Try removing it and recreating it from scratch.