A
Ac
Hi,
I had an input form taking the input from user and several queries did the
calculations. Based on the input data and the calculated results, I had to
create another table (originally it was in the Excel sheet, there were about
20 columns, and each time to run a batch calculation, it took about 300 rows
to complete. Lots of formulas in the cells used the data before or after
current rows or columns. I could not use the queries to do the calculation
because of this reason). I wrote a loop
inside of a module to calculate the results, and added the results into a
results table, finally I needed this table to create a chart inside of access
database. I finished all steps, it worked well.
The problem now is, there are 300 same charts displayed. I do not know where
those 300 charts are coming from; there are 300 new rows of data generated in
one batch calculation and replace the existing data in the ChartData table,
and the ChartData table is the data source of the chart. Is it the problem
coming from? How can I modify the code or properties to let only one chart
display. Your help is very much appreciated!
I had an input form taking the input from user and several queries did the
calculations. Based on the input data and the calculated results, I had to
create another table (originally it was in the Excel sheet, there were about
20 columns, and each time to run a batch calculation, it took about 300 rows
to complete. Lots of formulas in the cells used the data before or after
current rows or columns. I could not use the queries to do the calculation
because of this reason). I wrote a loop
inside of a module to calculate the results, and added the results into a
results table, finally I needed this table to create a chart inside of access
database. I finished all steps, it worked well.
The problem now is, there are 300 same charts displayed. I do not know where
those 300 charts are coming from; there are 300 new rows of data generated in
one batch calculation and replace the existing data in the ChartData table,
and the ChartData table is the data source of the chart. Is it the problem
coming from? How can I modify the code or properties to let only one chart
display. Your help is very much appreciated!