NathanSavidge
Registered User.
- Local time
- Today, 10:13
- Joined
- Apr 19, 2010
- Messages
- 12
Hi,
Yesterday i wrestled and finally got an OLE chart in my access form where it is linked to data from a query. I need to change the datasource to be the width of rst.recordcount, to get the data, as i am presenting by week/month/quarter.
I have been messing about with
Me!sbfChart.Form.OLEUnbound1.Object.Sheets(1).Chart.SetSourceData
but cant seem to get any joy
TIA
Yesterday i wrestled and finally got an OLE chart in my access form where it is linked to data from a query. I need to change the datasource to be the width of rst.recordcount, to get the data, as i am presenting by week/month/quarter.
I have been messing about with
Me!sbfChart.Form.OLEUnbound1.Object.Sheets(1).Chart.SetSourceData
but cant seem to get any joy
TIA
