I am a newbie in the process of writing my first VBA app to refresh and print a number of reports. I have so far automated all reports with fixed parameters but and have got as far as declaring and setting the value of the variables for the parameters on those reports that require them.
I am now stuck on how to pass these parameters to my SQL.
How do I pass these parameters across?
When running there will be some 20/30 reports all running with the same parameters.
I am now stuck on how to pass these parameters to my SQL.
How do I pass these parameters across?
When running there will be some 20/30 reports all running with the same parameters.