I have a Query which, when run from Access displays a dialog box requesting that a value is entered. The query works fine and returns the required information.
From within VBA (Excel) when I call this query using ADO command and parameter objects, it does not seem to have any parameters passed to it.
Is it possible to do this in Access - call a parameterised query, and if so how?
Regards
Viddy
From within VBA (Excel) when I call this query using ADO command and parameter objects, it does not seem to have any parameters passed to it.
Is it possible to do this in Access - call a parameterised query, and if so how?
Regards
Viddy