Bit of a Challenge

[Summerwind]

Hi Everyone.

I am building an app which will be used to administer a small company which has several mobile service engineers.

Everything is fine. A fairly standard sort of job until the client asked for a screen showing each engineer for a given day with a bar graph showing planned start and finish times for each allocated job, together with the location! As an added challenge, I need the user to be able to click on the "Chart" and so open another screen showing full details of the job clicked on.

My first approach was to use a chart. Couldn't do it

The approach I have now used is to create a series of labels on the form "On the fly" to represent each job and the unallocated time in between jobs. I can also run a macro to display the full job details when the label is clicked upon.

HOWEVER, this is a very cumbersome way of doing things to my mind. In addition, sizing of the controls in each day's bar is far more difficult than I expected.

Anyone got any ideas as to how I might achive this task in a more polished way?

 

[RuralGuy]

Here's a link you might find interesting. GANTT Chart for Scheduling Resources

 

[Summerwind]

Thanks. I'll have a look.

Cold in the Rockies now?

 

[RuralGuy]

+6c during the day and -9c at night.

 

[Summerwind]

Hmm. Temps not as low as I was expecting.

Had a look at your suggestion. Would be OK for creating chart but not for the rest of it.

Suppose I will have to stick with what I've got. At least it works, even if its not very elegant.

Merry Xmas.

 

[RuralGuy]

Merry Christmas to you too.