Q: Horizontal Slider Control on SubForms

[Endre]

Hello All, I am looking for a mechanism to create a "control" that represents the duration and possibly size of an object e.g. a Project.

Vertically I would like to see many Projects and horizontally a time scale. But each project is represented by a long rectangle, positioned correctly on the time scale for start and finish. Much like MSProject, but a simple version. However, I would like to be able to "grab" the ends of the rectangle and stretch it's size to change duration, or slide the rectangle horizontally. Here's the catch though - I would like it in a sub-form style to see multiple projects one on top of each other.

I've found doing something like this is OK, but as soon as you move to the next "record" in the sub-form, it's "rectangle" starts taking on properties of the previous record that held the focus. And the objects start jumping all over the place......

Each project will have a cost per time period (which would also be nice to have some way of displaying as the cost changes over the duration of the project), and the graph at the top of the entire form shows total project cost, or total cost of selected objects.

Any idea of how to create such a control that works on a "sub-form"?

Here is a really great example of a slider control on a main form created by ChrisO. It's pretty cool

See Post #4, http://www.access-programmers.co.uk/forums/showthread.php?t=177669

 

[YevS]

You want the users to be able to "stretch" those bars?

If not, I dont quite get why you are doing it in sub-forms. You could run code on "current" event of the main form that changes each bar to simulate child links in the back end using recordsets.

It's hard to see what you are trying to do I'm afraid, perhaps you can post a screenshot or something?

 

[Endre]

See example screenprint. Project_04 needs to be extended, so I want to stretch it into Week 28. Costs over time graph will update accordingly. I have implied the use of a sub-form as I don't know how many projects there may be. But, it could be done in a single form - would have to be recreated each time before even loading. So no .mde that way. Unless I can preload more projects on the form than would need to be used and change it dynamically.....