Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
no given value for required parameters
okay. nevermind. figured it out. i rechecked my query. thanks chris!- jerseyjo
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
no given value for required parameters
the issue is I'm getting the "no given value for required parameters" error. the strSQL is as follows "SELECT CorpDesc FROM rollup WHERE Company='ACI'" that looks right to me. yes, "ACI" is within the company field. NOTE: rollup is already a query, not a table. do you think that might cause...- jerseyjo
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
no given value for required parameters
below is my code: Sub MyFirstConnection() Dim con1 As ADODB.Connection Dim recSet1 As ADODB.Recordset Dim strSQL As String Dim strsearch As String strsearch = "ACI" strSQL = "SELECT CorpDesc FROM rollup" & _ " WHERE Company = " & " '" & strsearch & "'" Set con1 = CurrentProject.Connection...- jerseyjo
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
