Gantt Chart using Old IE Webbrowser control (1 Viewer)

[arnelgp]

Many times I've seen someone aspire to have a Gantt chart.
I have also made a simple one.
And I also saw something more complicated.
This comes from asking our favorite AI.
It uses the old IE webbrowser control.
I haven't thoroughly tested it yet.
Put the .html file on same folder as the database.

 

[Richard Rost]

Yeah, a student of mine asked me if it was possible to do a Gantt chart in Microsoft Access a few years ago, and I cobbled something together. And it works, but it's a lot of work. And honestly, something like this is better done in Excel. My database is pretty much a proof of concept that you'd need to put a lot more work into to get much use out of.

LLAP
RR

 

[Doozer]

Looks great! I was going to create a Gantt Chart next, but you beat me to it. I'll have to adapt yours to the Edge Browser.

 

[isladogs]

I strongly recommend looking at the interactive Gantt charts created in Access by Aleksander Wojtasz.
He demonstrated these to the Access Europe User Group on two occasions, most recently in 2024

Advanced Techniques with Interactive Gantt Charts

In July 2023 , Aleksander gave an excellent presentation on the use of his Interactive Gantt Chart Scheduler in Access. The session was very popular and the accompanying YouTube video has had by far the highest number of views (over 3400 to date) of all our meetings so far. The original session...

isladogs.co.uk

The video of both sessions are also on YouTube. This is the more recent one.

I think its great seeing both @Doozer and @arnelgp creating HTML solutions for what are otherwise complex tasks in Access.
However, in the long run, focusing on the Edge browser control is more beneficial.
Its worth bearing in mind that the old IE browser control will be deprecated this summer, at least in supported versions
Its long term status in older versions is less clear.

 

[arnelgp]

updated the chart to version 2.
added ability to resize the task pane (left side) by dragging on the blue dividing line.
note that you cannot narrow the task pane further if the delete (x) button will get hidden (or out of view).
added Days and Status column on the Task pane.
both task pane and the calendar pane now have same number of header rows.
makes the "Group" and Milestone marker little bigger or taller.

Its long term status in older versions is less clear.

I am submitting this for those who are still stuck with old ms access version (without the new edge browser control)

 

[arnelgp]

some minor fix, when the left pane is resized, each row's heigh increases/decreases but the right pane row does not change. have this fixed.
the Task bars' height also increases/decreases proportionally.
background is dimmed whenever pop-up window for New task or Edit task.
also "remember" the left pane's width and the row height and "remember" it when the form re-opens.

 

[Gasman]

I am submitting this for those who are still stuck with old ms access version (without the new edge browser control)

That would be me, for at least one here.

 

[Jason Lee Hayes]

updated the chart to version 2.
added ability to resize the task pane (left side) by dragging on the blue dividing line.
note that you cannot narrow the task pane further if the delete (x) button will get hidden (or out of view).
added Days and Status column on the Task pane.
both task pane and the calendar pane now have same number of header rows.
makes the "Group" and Milestone marker little bigger or taller.

I am submitting this for those who are still stuck with old ms access version (without the new edge browser control)

There is no denying it; utilizing HTML and JS this way will keep Access alive that little longer. Nice work; thanks for sharing...