Graphics

[Zinemon]

Hi,

1. I have to make a series of graphics, will I be better off making them in a form or in a report?

2. And by the way, since it concerns about 30 graphics and they will all look alike (same exes, same type of graphic), is there a quicker way than to do them one after the other?

Thanks

 

[Zinemon]

Anybody have an answer?

 

[boblarson]

Your post is confusing, so that's probably why you haven't had an answer.

1. What do you mean you need to make a series of "graphics?"

2. By "graphics" what do you mean? Are you meaning CHARTS?

3. What are they for?

 

[Zinemon]

1. I have to do many charts (same axes, same type of chart, same size of axes, etc.)

2. By graphics I mean charts.

3. They represent for example the costs of a vehicle as a function of the year.

 

[CraigDolphin]

Create a chart based on a query that uses the vehicle's ID field (and possibly also the year you are interested in) as a parameter to limit the results to one vehicle at a time (Probably you would make the user select a vehicle and/or year on a form and the control(s) on the form would be your criteria). Then, simply open the same chart after making the user pick which vehicle they want to get results for. The axes will scale differently depending on the values returned by the query.

 

[Zinemon]

Your answer is very interesting. However, I don't understand:
"Then, simply open the same chart after making the user pick which vehicle they want to get results for."

 

[CraigDolphin]

3. They represent for example the costs of a vehicle as a function of the year.

I was referring to the user picking which vehicle and year the graph shows details for.

 

[Zinemon]

But the user picks which vehicle he wants results for in the query or in the form? How can I manage that?

 

[CraigDolphin]

FormA> Users selects vehicle (VehicleID) in ComboBoxZ and Year in ComboBoxAA. Once selection is made (test that both Combos have had something selected), FormA is made invisible (Forms!FormA.Visible = False). FormB then opens.

QueryA uses Forms!FormA!ComboBoxZ as a parameter criterion in the VehicleID field, and Forms!FormA!ComboBoxAA as a parameter criterion in the Year field.

FormB (unbound) contains a chart based on QueryA. (When FormB closes make sure to close FormA in the close event of FormB [and test to make sure FormA is loaded before trying to close it])

One chart will work for whichever vehicle/year is selected by the user.