Gantt Chart using Old IE Webbrowser control (1 Viewer)

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 10:06
Joined
May 7, 2009
Messages
20,694
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.
 

Attachments

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
 
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. :)
 
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


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.
 
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)
 

Attachments

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.
 

Attachments

Last edited:
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.
 
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...
 

Users who are viewing this thread

Back
Top Bottom