How do you create charts in Microsoft access 2000?
I need the chart to change with each record.
As is so often the case, there are several techniques you might use, but the best solution is for you to create a template and then at run time adjust the various settings of the different controls.
For example, if you build a line graph, you need only adjust the Left and Top properties of the [data] points and then draw a line (using the Line method) to connect those dots.
Or, you can build a bar chart and do pretty much the same thing: adjust the Top (or Width, if it’s a aligned horizontally) property to fix the bar’s height.
You really need a copy of Access 2 Power Programming…
February 8th, 2010 at 12:45 pm
As is so often the case, there are several techniques you might use, but the best solution is for you to create a template and then at run time adjust the various settings of the different controls.
For example, if you build a line graph, you need only adjust the Left and Top properties of the [data] points and then draw a line (using the Line method) to connect those dots.
Or, you can build a bar chart and do pretty much the same thing: adjust the Top (or Width, if it’s a aligned horizontally) property to fix the bar’s height.
You really need a copy of Access 2 Power Programming…
References :