VB6 to define regions and create access table 1

[scousethemoose]

I am currently transfering an Access VBA Database for assets to VB6 to standardise it, this is pretty straignht forward. However I want to allow a user to load a picture of a factory floorplan and define custom regions on it, the regions will be particular areas of the plant. I want the region information to be stored in a table called tblPlant. It will have these fields:

- RegionID
- RegionName
- RegionDescription

Once the plant has been defined and saved a user can then modify existing regions, add new regions and delete them if no assets are stored in the particular region. At any time a user can then view the plant and click a region and assets within it will be displayed.

I was able to get this to work in Access with VBA by hard coding the plant definition but I now want a user to be able to define there own plant.

Any ideas?

 

[NobleDBell]

Phew! That is a mouthful. If you can give me a little more information about how you plan for the user to define the regions I might be able to get you on the right track.

Noble

 

[scousethemoose]

Sure, my intention is to allow the user to draw directly on to the loaded picture with custom predefined shapes, circles squires etc. Once drawn each shape will have its own set of properties such as.

- RegionID
- RegionName
- RegionDescription

This will be achieved using the rubberband drawing method, hopefully, but also have a freehand option. I think I just need a little help with the drawing at the moment, and how to keep track of the shapes drawn so that they can be edited and moved around on the plan. I think I'll probably have to store the shapes in an array as and when they're drawn.

Hopefully you can see what I'm trying to achieve now. Any help would be great