Here is the format of each query:
Expand|Select|Wrap|Line Numbers
- Set qdf20 = db.QueryDefs("<Query Name Here>")
- qdf20!Param1 = Param
- Set rst20 = qdf20.OpenRecordset()
- qdf20.Close
- rst20.Close
- Set qdf20 = Nothing
- Set rst20 = Nothing
Solutions I have tried are using the Parameters Collection Object, and using the SQL commands directly in VBA, but that didn't help. The error I receive is: "Too few parameters, expected 1". I have read the other posts concerning this same error, but they do not solve the problem.
I'm at my wits-end trying to find a solution. Can anyone offer any insight? It would be very helpful and much appreciated.