Hi All,
I can't get this simple query wroking in my Code....I am getting following error while running it
"Run-time error 3061" Too Few Parameters, expected 2"
Here is my Code:
Dim Fname As String
Dim ID As Integer
Dim SSQL As String
Dim SSQL1 As String
Fname = Trim(List_Resource_Combo)
ID = Forms!Add_Project_Details!Oppt_ID
SSQL = "UPDATE Sales_Pipeline_Current SET [Sales_Pipeline_Current].R_List = Fname where [Sales_Pipeline_Current].oppt_Id = ID ;"
Set db = CurrentDb()
db.Execute (SSQL)
db.Close
I made sure Both the variable (Fname and ID) are assigned values. Query runs fine in Access Query Wizard..
Thanks
Parth
I can't get this simple query wroking in my Code....I am getting following error while running it
"Run-time error 3061" Too Few Parameters, expected 2"
Here is my Code:
Dim Fname As String
Dim ID As Integer
Dim SSQL As String
Dim SSQL1 As String
Fname = Trim(List_Resource_Combo)
ID = Forms!Add_Project_Details!Oppt_ID
SSQL = "UPDATE Sales_Pipeline_Current SET [Sales_Pipeline_Current].R_List = Fname where [Sales_Pipeline_Current].oppt_Id = ID ;"
Set db = CurrentDb()
db.Execute (SSQL)
db.Close
I made sure Both the variable (Fname and ID) are assigned values. Query runs fine in Access Query Wizard..
Thanks
Parth
Last edited: