Interactive map of 1000 seats

[chacham]

The link Post #4 looks quite good, but the limitation on objects on the form might be a problem. Also, that is a designing tool, and i am not sure how well that would translate into code afterwards. I didn't realize post #6 was a different link! Is that the same program? They haven't yet given me a Windows laptop, so i have not been able to check out the code directly.

The rows and seats are not so uniform. The seats are the same size, but where they line up is different, due to polls or whatnot. That is why a map seems so attractive, even though the coordinates would need to be recorded for each seat. As the seats rarely change, however, i am not sure that is much of a problem.

You say subforms are not much more complex. Would i be able to use a few of them seamlessly to give the the impression of it being exactly one map? The subforms have the advantage of not having to worry about size. Also, would i have to code each button separately?

[Bulzie]

So placing seats in a room, will it always be the same format or could it change constantly. If it can and needs to change that adds difficulty to your process. Also does it have to "appear" just like the room layout where you might have a column, tables, podium, etc. or can it just be a form for each room that has just seats in a row like one of the posts in the other forum thread? Being able to click a seat object and see data or update data should not be an issue.

As far as coding, if you name the objects (rooms and seats) as say R1S1 for room1 seat1, R1S2, R1S3....R2S1 room2 seat1, or if you need to keep all seats going numerically, maybe R2S501 to start with seat 501 in room 2, etc. then you can use code to loop through these objects names if needed. So these would all be fields in the various tables and subforms.

[aytee111]

Yes, each "seat" would need to be programmed separately, altho as stated it can be a common routine for each, just passing it the object name.

The link in post # 6 looks perfect for your requirements. It has a room layout with rows and seats, on mouse-over you can see the details for each seat, and it changes color when booked.

[chacham]

The link in post # 6 looks perfect for your requirements. It has a room layout with rows and seats, on mouse-over you can see the details for each seat, and it changes color when booked.

Thank you. I will have to take a look at that then. Now, i just need that Windows laptop...

[aytee111]

Not sure what you need, would it help to attach it to this post?

[chacham]

Oh, i just need a Windows laptop so i can get to work. They are supposed to provide one for me, or at least a place to work, because i do not have Windows myself.