No value given for one or more required parameter.

[nhaider]

Hi All
I am trying to insert the field value which is depended on formula
into the table. The given field me.field28 and me.nodlyd are working
but me.field34 is not working and the givne error message is
displayed.

No value given for one or more required parameter.
Could you try to solve this problem.

Thanks in advance

Dim mycon As New ADODB.Connection
Set mycon = New ADODB.Connection

Dim iSQL As String
Dim dSQL As String

mycon.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0; " &
"Data Source =" & "D:\Naushad\viewTest.mdb" & ";" & "User Id = admin;"
& "Password ="
mycon.Open

dSQL = "DELETE FROM tblstage"

iSQL = "insert into tblStage (Stage_code, TotProject, NoOfDelayed)
select [" & Me.Field34 & "] , " & _
Me.Field28 & " , " & Me.NoDlyd & " ;"

mycon.Execute dSQL, dbFailOnError
mycon.Execute (iSQL)
End Sub

Naushad

[Scott McDaniel]

On Wed, 20 Jun 2007 00:48:16 -0700, nh*****@kockw.com wrote:

>Hi All
I am trying to insert the field value which is depended on formula
into the table. The given field me.field28 and me.nodlyd are working
but me.field34 is not working and the givne error message is
displayed.

No value given for one or more required parameter.
Could you try to solve this problem.

Generally, this error means that you've misspelled a table or column name. Check your spelling thoroughly and try it
again.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

[nhaider]

On Jun 20, 1:12 pm, Scott McDaniel <scott@NoSpam_Infotrakker.com>
wrote:

On Wed, 20 Jun 2007 00:48:16 -0700, [e-mail] wrote:

Hi All
I am trying to insert the fieldvaluewhich is depended on formula
into the table. Thegivenfield me.field28 and me.nodlyd are working
but me.field34 is not working and the givne error message is
displayed.

Novaluegivenforoneormorerequiredparameter.
Could you try to solve this problem.

Generally, this error means that you've misspelled a table or column name. Check your spelling thoroughly and try it
again.

Scott McDaniel
scott@takemeout_infotrakker.comwww.infotrakker.com

Hi Mr. Scott

I Checked the table or Column name, all are correct. Actually the
column me.field34 is based on the below formula.

=IIf([Forms]![frm800 Analysis - Menu for schedule Analysis]!
[Stage]=1,"Design",IIf([Forms]![frm800 Analysis - Menu for schedule
Analysis]![Stage]=2,"Contract",IIf([Forms]![frm800 Analysis - Menu for
schedule Analysis]![Stage]=3,"Construction","Overall Project
Completion")))

The value in current form is comming from [frm800 Analysis - Menu for
schedule Analysis]![Stage] which is the radio group.

Please try to solve the problem.
Thanks...................