Ghantt charts

[pekajo]

Hi,
Can anyone give me advice or example of producing a ghantt chart in ms access
Thanks for any help
Peter

 

[amorosik]

Interactive Gantt Chart Scheduler in Access

This month’s session will be led by Aleksander Wojtasz and used to demonstrate the use of his interactive Gantt chart scheduler in Access

isladogs.co.uk

 

[isladogs]

Look at the video and example apps created by Aleksander Wojtasz for the Access Europe User Group

https://isladogs.co.uk/aeu-31

EDIT: There are 2 sessions/videos. @amorosik has supplied the first and I’ve given the second. Both are excellent!

 

[arnelgp]

i think he wanted to create, not to Buy..

 

[isladogs]

Aleksander provides free example apps for others to adapt.

 

[arnelgp]

yeah right, like in .accde or in .mde?

 

[isladogs]

@arnelgp
Just for once why don’t you check rather than make incorrect, negative comments.
The files are ACCDB

 

[arnelgp]

NO, i don't need to buy anything from anyone.

 

[amorosik]

Aleksander provides free example apps, source code, excellent source code
And it doesn't seem to be explicitly asking for money
Of course, if you send him something, he's probably happy
Not because of the money, but because it means his work has been appreciated

 

[arnelgp]

Aleksander provides free example apps, source code, excellent source code

did you get his Gantt Chart for free?

 

[amorosik]

No, I haven't used it
But I know for sure it's there because I've seen it
It's not clear why you're asking these questions; you can easily check it out yourself.

EDIT: So out of curiosity, I tried, there is Demo_GanttChart.zip file that contains the WorkingModel_board-final-2023-07-04.accdb file, which is fully functional and editable.

 

[isladogs]

As already stated, all the examples are supplied free as fully working ACCDB files with all code
They have been downloaded and used by many people.

 

[arnelgp]

Aleksander provides free example apps, source code, excellent source code

how about support, is he willing to train and give support for Free?
i've seen his demo, but it is ridiculus to work with, specially the mouse.

 

[dalski]

A little askew, but I have used quite a few programming/ scheduling applications:

• Various Gantt Charts in Excel - paid & free; they are not very good
• https://elecosoft.com/products/asta/asta-powerproject/ - this is the UK standard application for scheduling construction projects & every single company I deal with uses it; industry standard application! I think it was around £1,300 a few years ago, no doubt they've moved to subscription like everyone else.
• https://www.aecsoftware.com/project-management-software/fasttrack-schedule-2024/ - around £200 for purchase outright. Excellent application; just like Asta but a fraction of the cost. Asta may be the industry standard but I have not come across something I needed to do in Asta that i could not do in FastTrack Schedule. The user manual is two inches thick when printed double-sided. I bought two copies; one for my Mac, another for Windows.

 

[Peter Hibbs]

Hi Peter,

Perhaps the attached demo will give you some ideas. There are three databases which have slightly different facilities, Demo 1 is the earliest and the enclosed User Manual refers to this version. Demos 2 and 3 have additional features which are not mentioned in the User Manual but I am sure you can figure out what they do, if you need any further information then just let me know.

To see some examples of projects, just change the date field at the top of the form to October 2015 for Demo 1 and 2018 for the other two.

Good luck with your project,

Peter Hibbs.

 

[amorosik]

how about support, is he willing to train and give support for Free?

The code is exactly what user pekajo requested

i've seen his demo, but it is ridiculus to work with, specially the mouse.

This is your opinion; it seems like very interesting code to me
And considering that it allows adding new tasks and dragging and dropping individual tasks, including changing interactively their duration, in my opinion it's better than many other examples.

 

[arnelgp]

i've never use a gantt chart, so my sample simple gantt chart might not have
the function you are looking. but this is an entry level, no sub-category, just
straight single tasks.

it took me some hard thinking on this one.

 

[Mark_]

Is this for display in a report or on a form?

Are you already able to create the start/end dates for each task and set up the dependencies?