C
ChrisM
Hi,
I have a query in Access that requires a parameter. (ie when you run the
query in Access, it pops up a parameter box asking for the param value).
If I am calling this query from elsewhere (A report designer), is there a
way of passing the parameter into the query? I know how to do this with ADO
command and parameter objects, but it would seem that in this instance, the
only way so call the query is through a SQL string:
ie: SELECT * FROM MyQuery
Anyone got any ideas? FWIW, it is ActiveReports that I am using, so if
anyone knows how to call a query with parameters in ActiveReports, I would
be most grateful.
TIA,
ChrisM.
--
Please remove shoes to reply
But what ... is it good for?
- Engineer at the Advanced Computing Systems Division of IBM, 1968,
commenting on the microchip.
I have a query in Access that requires a parameter. (ie when you run the
query in Access, it pops up a parameter box asking for the param value).
If I am calling this query from elsewhere (A report designer), is there a
way of passing the parameter into the query? I know how to do this with ADO
command and parameter objects, but it would seem that in this instance, the
only way so call the query is through a SQL string:
ie: SELECT * FROM MyQuery
Anyone got any ideas? FWIW, it is ActiveReports that I am using, so if
anyone knows how to call a query with parameters in ActiveReports, I would
be most grateful.
TIA,
ChrisM.
--
Please remove shoes to reply
But what ... is it good for?
- Engineer at the Advanced Computing Systems Division of IBM, 1968,
commenting on the microchip.