R
rdemyan via AccessMonster.com
I have a number of charts in my application. The chart is set via the
RowSource property.
In the past I have occassionally been having problems with the chart updating
correctly. Sometimes it would fail and data that displays in the chart when
the form is in design mode would display. Since this was misleading, in form
design mode, I deleted the data present in the chart table. Now when the
chart fails to update with data, the chart is blank, which is at least
misleading.
The problem is that these failed attempts to update the chart are beginning
to increase. Just this afternoon I tried about 10 times to get the chart to
update and it wouldn't. Finally, it did and thereafter worked fine. It was
kind of like "priming a pump".
Here's typical code that I use to set the chart rowsource:
Me.Usage_Chart.RowSource = "SELECT USAGE_YEAR, USAGE FROM
[FACILITY_UTILITY_USAGE_TABLE] Order By [USAGE_YEAR] ASC;"
Me.Usage_Chart.Requery
Why wouldn't this work flawlessly every time?
Is there something else I need to do or perhaps ensure that some chart
property is set correctly.
Any advice is appreciated.
RowSource property.
In the past I have occassionally been having problems with the chart updating
correctly. Sometimes it would fail and data that displays in the chart when
the form is in design mode would display. Since this was misleading, in form
design mode, I deleted the data present in the chart table. Now when the
chart fails to update with data, the chart is blank, which is at least
misleading.
The problem is that these failed attempts to update the chart are beginning
to increase. Just this afternoon I tried about 10 times to get the chart to
update and it wouldn't. Finally, it did and thereafter worked fine. It was
kind of like "priming a pump".
Here's typical code that I use to set the chart rowsource:
Me.Usage_Chart.RowSource = "SELECT USAGE_YEAR, USAGE FROM
[FACILITY_UTILITY_USAGE_TABLE] Order By [USAGE_YEAR] ASC;"
Me.Usage_Chart.Requery
Why wouldn't this work flawlessly every time?
Is there something else I need to do or perhaps ensure that some chart
property is set correctly.
Any advice is appreciated.