This is probably really easy, and may have been answered before, but I can't seem to find it.
How do I pass a parameter to a stored query in an Access database? I'm building a different query in code, and it joins a table to a stored query that requires a parameter. I tried using the QueryDefs.Parameters collection in DAO to set it, but when I do my Database.OpenRecordset with the SQL I built in code, I just get an error saying I didn't pass it enough parameters.
I'm probably missing something obvious, I just don't know what. Anyone have any ideas?
How do I pass a parameter to a stored query in an Access database? I'm building a different query in code, and it joins a table to a stored query that requires a parameter. I tried using the QueryDefs.Parameters collection in DAO to set it, but when I do my Database.OpenRecordset with the SQL I built in code, I just get an error saying I didn't pass it enough parameters.
I'm probably missing something obvious, I just don't know what. Anyone have any ideas?