Create a line with multiple points on a form (1 Viewer)

[TOMcatmen]

While creating a program I ran into the problem of a maximum number control on a form.
As you can see in the appendix, I want to make a graph showing which position a driver has driven during the race.

Of course I tried to do it with chart first, but that didn't get the desired result. So I started programming something in VBA, where I already have the number of line pieces on the form, which are then put in the right place with VBA. Since there could be 110 laps and I want to show max. 25 drivers, I get a very large number of line segments, which is more then MS-Access allows.

Is there a possibility to create a line that has multiple points so that it is one line from start to end, so I have only one line instead of ma. 110 line segments?

François van Riel

 

[theDBguy]

Hi. Welcome to AWF!

The only thing I could think of at the moment is somehow create the line with multiple point outside of Access and convert it into an image and then display it on a Form in Access.

Hope that helps (somewhat)...

 

[CJ_London]

you might want to take a look at stephen lebans paint program https://www.lebans.com/paintprogram.htm

the lines are created by using mousemove, but I'm sure you can modify based on line positions

 

[arnelgp]

add Image Control to your Form.

use Excel to Plot those data.
Import the Image to Chart object.
export the Chart object as Picture.

set the Picture property of the Image
to the path where you saved the image
file from Chart object.

 

[TOMcatmen]

This involves over 1000 of these charts, so I want to do it with VBA so that I have a dynamic environment.

 

[arnelgp]

you only showed 1, so you create 1 at a time.
it's only a suggestion, you don't need to listen.

 

[TOMcatmen]

CJ_London

I will take a closer look at this, whether this can provide a possible solution