sql error message

[Shokoth]

Hi
I have been trying to run this code, and what it is doing is inserting records into a table called tblRequestBySer vice. the values that it is inserting are taken from the form itslef (They are normal text boxes). every time i click the button to do that, i get the folling error message:

"Number Of Query Values and Destination Fields are not the same". I have been having similar problems throughout. i know that the number of fields that i am inserting is the same number of fields on the actual table.

This is the code that i hjave been using.

Dim strSQL As String

strSQL = "INSERT INTO [tblRequestBySer vice]([Serviced Requested], [Service Provider], [Requested By], [Start Date], [Duration]) " & _
"VALUES (forms![frmSearchServic e].[txtForService], forms![frmSearchServic e].[txtServiceProvi dedBy], forms![frmSearchServic e].[txtRequestBy], forms![frmSearchServic e].[txtRequiredDate], forms![frmSearchServic e].[txtDuration],1);"
DoCmd.RunSQL strSQL

End Sub



Please can anyone tell me how to solve this problem

[MMcCarthy]

Your query has 5 fields and 6 values. Remove the ",1" from the end of the statement as follows:

Dim strSQL As String
 
strSQL = "INSERT INTO [tblRequestByService] " & _
   "([Serviced Requested], [Service Provider], [Requested By], [Start Date], [Duration]) " & _
   "VALUES (forms![frmSearchService].[txtForService], forms![frmSearchService].[txtServiceProvidedBy], " & _
   "forms![frmSearchService].[txtRequestBy], forms![frmSearchService].[txtRequiredDate], " & _
   "forms![frmSearchService].[txtDuration]);"
DoCmd.RunSQL strSQL
 
End Sub
 

Mary

[Shokoth]

thanks.

I am also trying to open up a from in add mode, from another form.
i have one form, and wen u click a button, it should take you to another form (from a different base table), and open that up in add mode.
I have tried a few several ways, but it doesn't work.
How is the solved

[MMcCarthy]

thanks.

I am also trying to open up a from in add mode, from another form.
i have one form, and wen u click a button, it should take you to another form (from a different base table), and open that up in add mode.
I have tried a few several ways, but it doesn't work.
How is the solved

This will open a form in Add mode

DoCmd.OpenForm "FormName", , , , acFormAdd