Lets be honest, it's a pretty awesome name...
I currently have a pass-through set up, but i keep getting an error:
ODBC--call failed[Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to date. (#8114)
Here is my VBA that pass the @startDate and @EndDate to the pass through query:
Dim DB As Database
Dim A As QueryDef
Dim B As String
Dim S As String
Dim E As String
S = Forms!StartAndEndDate![@StartDate]
E = Forms!StartAndEndDate![@EndDate]
B = Forms![StartAndEndDate]![RunQuery]
Set DB = CurrentDb()
Set A = DB.QueryDefs(B)
A.SQL = "exec dbo.usp_" & B & " '" & S & "'" & "'" & E & "'"
Any suggestions on what I need to change?