Hi everybody,
I have an MS Access form with a table subform and XY diagram subform which graphically shows the table data coming from a standard MS Access table. The XY graph displays a polynominal trendline for my data (the trendline has been generated using standard Access menus/windows) and the related trend equation (which also can be easily generated by standard Access menus/windows).
As a result the XY diagram shows the data points, a trendline and an equation such as "y = 7x^E2 + 4056" on the graphic.
I actually want to do further calculations with this trendline equation.
My question: How do I get (can I work with) this equation into my vba without actually typing it to allow further automated calculations on the same form?
I understand, this is not so usual. Anyway, all help & hints are appreciated,
georgp
I have an MS Access form with a table subform and XY diagram subform which graphically shows the table data coming from a standard MS Access table. The XY graph displays a polynominal trendline for my data (the trendline has been generated using standard Access menus/windows) and the related trend equation (which also can be easily generated by standard Access menus/windows).
As a result the XY diagram shows the data points, a trendline and an equation such as "y = 7x^E2 + 4056" on the graphic.
I actually want to do further calculations with this trendline equation.
My question: How do I get (can I work with) this equation into my vba without actually typing it to allow further automated calculations on the same form?
I understand, this is not so usual. Anyway, all help & hints are appreciated,
georgp