Sync Scrolling on subforms

[steve1111]

Hello all,

I am creating a 5-day calendar, much like outlook, for driver jobs and times. I find the best way to do this an achievement an "endless" horizontal scroll past the 22-inch limit is to build 4 subforms and have each hold a driver rides for the day. This way certain regions that have 50 drivers can be scrolled from left to right. Something like below with each chunk a subform.

      unassigned         Driver1        Driver 2       Driver 3
         M T W R F        M T W R F    M T W R F    M T W R F
700       2                     3    6
730          4
800
830
etc

I want to list the time labels just once on the unassigned subform from 700AM-6PM in 30-minute chunks. this will mandate I will need to use a vertical scrollbar. Since I am comparing openings on different drivers schedules to assign jobs, I want to be able that when I am in any of the four subforms if I scroll or mouse wheel in that subform the rest of the subforms move in sync. so that if I scroll from 7 AM to 3 PM all the drivers move and the "imaginary row" across my entire form is all positioned the same time.

I hope I am explaining that well, not sure if this is possible. Does anyone have some ideas on how to do this? Thanks

 

[Mark_]

For myself, I would rotate the entire design 90 degrees.

Across the top your fixed data (time periods) and then your sub form would show availability for each driver. Each record would have a label for each 30 minute period. Set the color to what ever you want for "Available", "On job", "Not available", "what ever". A bit of a pain to set up the first time, but it is a working solution for these types of charts when you want to display in a continuous subform.

NOTE: This also avoids the issue when you have 150 drivers and your trying to figure out who's available when and you've decided you can't get a 5m wide screen to show it on.

 

[isladogs]

I use a vertical scroll instead which avoids issues with maximum form width (but I don't have multiple users on one screen)
See attached screenshots for form and design view.

If that looks any use to you, feel free to ask me specific questions about implementation

The same form has links to a monthly & daily calendar of similar layout

 

[steve1111]

Thank you ridders and Mark, but I don't think rotating will work for me in this case because I would still need to simultaneously scroll each driver subform, only with rotating it would be horizontally rather than vertically.

Each driver would have to show in its own subform for 5 days.

 

[isladogs]

Did you look at my screenshots?
I have days across the top and times going down the page which is what I thought you wanted after reading post 1

However, I think Marks suggestion may be better for your purposes with 50 drivers

If you do a site search, you will find examples of syncing subforms

 

[steve1111]

I did see the screenshots but what I am trying to do is make individual work weeks for each driver. Your shots are nice, but I need M-F to repeat under each driver.

Marks suggestion is valid, but the details of the cell and 24-time blocks I am not sure flipping solves anything for me. I would just have to stack the driver 5-day subforms on top of each other rather than next to and still need them to scroll at the same time, that way would just be horizontal rather than vertical.

I did just see Sonic8 had a link under one of the posts to a demo he had, I will give that code a try...