I have a VB App that instantiates a Access Application from which I
have triggered the running of reports using the standard
DoCmd.OperReport. This is an automated printing app that just reads
parameters in a database and then just prints the report OR emails
them to a recipient.
My problem is that we have switched our backend to MSSQL 2000 and
Access is the front end.
I need to, prior to running the report change a number of properties
in the report, eg we are now running stored procedures on some reports
so the "inputparameters" property is prepared ahead of time and just
loaded. I also need to change a number of other properties at the same
time, e.g. Caption etc.
Does anyone have a clue how to script this, noting that doing changes
in design mode is NOT an option as this is a Multi-User environment.
TIA
Edd