M
Morten Snedker
In a report I have a MS Graph Object displaying a graph. The
underlying data source is a stored procedure that takes a year (int)
as argument.
Is there anyway to pass the argument programatically? The objects
RecordSource property is not available in VBA, even though it should
be according to the online help.
As it is now a parameter box pops up asking for the parameter. I would
like to avoid this. The alternative is to run up against Excel, but
this is most certanly a Plan-B.
The solution runs Access 2002 (XP).
Regards /Snedker
underlying data source is a stored procedure that takes a year (int)
as argument.
Is there anyway to pass the argument programatically? The objects
RecordSource property is not available in VBA, even though it should
be according to the online help.
As it is now a parameter box pops up asking for the parameter. I would
like to avoid this. The alternative is to run up against Excel, but
this is most certanly a Plan-B.
The solution runs Access 2002 (XP).
Regards /Snedker