I have inherited a database which generates graphs on a form using an over complex series of queries
I need to be able to export the graphs to a .PDF document.
There are multiple graphs (31) which may be column or line graphs, each having different titles and axis labels. So far I have created a blank report with the appropriate page headers etc. which contains a chart object. The problem is I am unable to transfer the graph from the form to the report.
Also the commands I use to set the chart object titles and axis labels work for a form, but not for the chart object in the report.
For example
For the form
Set mainGraph = Forms!GraphTableDashboard!NavSubform!SubFormOSPlot!PlottingGraph.Object
mainGraph.ChartTitle.Caption = "A Chart Title "
Can be used to set the chart title, however taking the same approach on the report fails as the methods are not available.
Reports!ReportOSPlot_line!PlottingGraph.ChartTitle.Caption = "NEW TITLE" <<-- FAILS invalid method. :banghead:
I've been trawling the internet for some time now, and been unable to solve the problem.
I need to be able to export the graphs to a .PDF document.
There are multiple graphs (31) which may be column or line graphs, each having different titles and axis labels. So far I have created a blank report with the appropriate page headers etc. which contains a chart object. The problem is I am unable to transfer the graph from the form to the report.
Also the commands I use to set the chart object titles and axis labels work for a form, but not for the chart object in the report.
For example
For the form
Set mainGraph = Forms!GraphTableDashboard!NavSubform!SubFormOSPlot!PlottingGraph.Object
mainGraph.ChartTitle.Caption = "A Chart Title "
Can be used to set the chart title, however taking the same approach on the report fails as the methods are not available.
Reports!ReportOSPlot_line!PlottingGraph.ChartTitle.Caption = "NEW TITLE" <<-- FAILS invalid method. :banghead:
I've been trawling the internet for some time now, and been unable to solve the problem.