M
Mike P
I am running a query in VBA that uses parameters and multiple data sets.
However, it is failing with a Operation Not Allowed When Object is Closed
error when I attempt to Open the RecordSet Any ideas?? Thanks in advance
for your time - Mike
'-- Start Code
rs As New ADODB.Recordset
strSQL = "SELECT tblMaster.sym, tblProbability.CustID, tblMaster.Company,
tblFormula.Group, "FROM tblMaster INNER JOIN (tblProbability INNER JOIN
tblFormula ON tblMaster.CustID = tblProbability.CustID WHERE
(((tblMaster.myDate)=#" & datMyDate & “# ))â€
rs.Open strSQL, CurrentProject.Connection, adOpenDynamic, adLockOptimistic
'-- The Open above Fails
'-- End Code
However, it is failing with a Operation Not Allowed When Object is Closed
error when I attempt to Open the RecordSet Any ideas?? Thanks in advance
for your time - Mike
'-- Start Code
rs As New ADODB.Recordset
strSQL = "SELECT tblMaster.sym, tblProbability.CustID, tblMaster.Company,
tblFormula.Group, "FROM tblMaster INNER JOIN (tblProbability INNER JOIN
tblFormula ON tblMaster.CustID = tblProbability.CustID WHERE
(((tblMaster.myDate)=#" & datMyDate & “# ))â€
rs.Open strSQL, CurrentProject.Connection, adOpenDynamic, adLockOptimistic
'-- The Open above Fails
'-- End Code