No Value Given for the Required Parameter

no value given for one or more required parameters

The usual reason for this error is a missing or misspelled value. It seems likely that adminName is Null or a zero-length string.

No value given for one or more required parameters When all parameters are given

Here is part of the article about how to insert values in MS Access.
To add one record to a table, you must use the field list to define which fields to put the data in, and then you must supply the data itself in a value list. To define the value list, use the VALUES clause.

For example, the following statement will insert the values "1", "Kelly", and "Jill" into the CustomerID, Last Name, and First Name fields, respectively.

INSERT INTO tblCustomers (CustomerID, [Last Name], [First Name])
VALUES (1, 'Kelly', 'Jill')

You can omit the field list, but only if you supply all the values that record can contain.

INSERT INTO tblCustomers VALUES (1, Kelly, 'Jill', '555-1040',
'someone@microsoft.com')

Source MSDN How to: Insert, Update, and Delete Records From a Table Using Access SQL

No value given for the required parameter

You have typed one of your columns incorrectly, and Access thinks you are trying to pass a parameter.

Go over your field names again and make sure they have all been entered correctly.

I believe the problem may be this:

SUM(Less90) + SUM(Between90180) + SUM(Between180365) + SUM(GreaterThan365) 
                 AS Total

And then you refer to it later as Total here:

SUM(Between180365) / Total

Access can't take the alias and re-use it in the query, you need this:

SUM(Between180365) / 
    (SUM(Less90) + SUM(Between90180) + SUM(Between180365) + SUM(GreaterThan365))

Also make sure you handle the denominator so you don't divide by zero.

Oledb No Value Given for one or more required parameters VB.NET

This Question was answered by MatSnow and olivier-jacot-descombes in the comments, the correct code looks as follows

Private Sub TestButton_Click(sender As Object, e As EventArgs) Handles TestButton.Click
    'connects application to database
    Dim ConnString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\DatabasePath\Database.accdb"
    Dim SqlString As String = "update SaintStaff set StaffHours = @CAHours, RecordedTime = @Time where StaffName = @staffname "

    'updates record in  SaintStaff table.
    Using conn As New OleDbConnection(ConnString)
        conn.Open()
        Using cmd As New OleDbCommand(SqlString, conn)
            cmd.CommandType = CommandType.Text
            cmd.Parameters.Add("@CAHours", OleDbType.VarChar).Value = Label6.Text
            cmd.Parameters.Add("@Time", OleDbType.VarChar).Value = Label10.Text
            cmd.Parameters.Add("@Staffname", OleDbType.VarChar).Value = Label2.Text
            cmd.ExecuteNonQuery()
        End Using
        conn.Close()
    End Using
End Sub

No value given for one or more required parameters. error during Search

I suppose that the error is in the text asd passed as value for the customer name

cmd = New OleDbCommand("Select * from PO_Record_Table where Customer='asd'", con)

Putting it in single quotes allows the db engine to recognize it as a string value to check against the Customer column name. Without quotes it is interpreted as the name of a parameter that you haven't passed to the command.

EDIT In your comment below you try to pass, as value for the Customer column, the content of a textbox but you forget to add the quotes around your textbox text value.

cmd = New OleDbCommand("Select * from PO_Record_Table where Customer='" & textbox.text & "'", con)

However, this should never be done using the string concatenation method, but always with the parameterized approach

cmd = New OleDbCommand("Select * from PO_Record_Table where Customer=@custName", con)
cmd.Parameters.AddWithValue("@custName", Txt_Find.Text)
dr = cmd.ExecuteReader
.....

This is the only good method to query a database passing a command text with values obtained by user input. This method allows your code to be safe from SQL Injection attacks and remove problems in parsing the content of the textbox. Infact, without a parameter and if your textbox contains a single quote, the string concatenation method would fail with a syntax error.

MS Access: No value given for one or more required parameters

Solved:

The query result view in MS Access showed the field name to be "emp_id", but the actual name was "employee_id".

The program using the database used to be an Access-forms application and therefore had different names on the columns in the query result view than the actual names (for some reason, I don't know why that sounded like a good idea)

---

Related Topics