This is VB6 and Access 2000. The following code snippet very nicely calls a stored query in an Access database: conn.Open "dbtest" Dim rsTemp As ADODB.Recordset Set rsTemp = conn.Execute("Query1") If ...
I've defined a simple select query in Access that retrieves data for a particular date. I execute the query from VBA. Is it possible to pass a parameter into the query from the VBA when I execute it?