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…

One Response to “How do you create charts in Microsoft access 2000?”

  1. Professor Says:

    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 :

Leave a Reply