Access Europe – Aleksander Wojtasz (Advanced Techniques with Interactive Gantt Charts)
Please join us for our monthly Access Europe session on Wed 4 Sept 2024 at 18:00 (6:00PM) London time (UTC+1)
You can click the button below to download a small calendar (.ics) file and add the meetings to your Outlook calendar. This will add a recurring appointment to the first Wednesday of each month.
Outlook Calendar (.ics)—————————————————————————————————————————————————————–
Topic Outline:
In July 2023 , Aleksander gave an excellent presentation to Access Europe 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 was used to explain how GDI is used with Access VBA to allow drawing of shapes such as lines, rectangles etc on Access forms and to move these using drag and drop.
We are very pleased to welcome back Aleksander for a follow-up session where he will explore more advanced techniques with interactive Gantt charts.
In this session, Aleksander will explain how he has upgraded the code which now uses a class module approach with the Scripting Dictionary now being used to manage the size and position of objects placed on the screen.
Of these, the most important is the GanttChart class which generates it’s own events (WithEvents) :
So whenever any action occurs on the GanttChart (e.g. an object is dropped or mouse double click), the Gantt Chart object fires the events so the Access developer can react on such an events accordingly by writing suitable event handler code.
This new approach makes the code easier to understand with a clear division between code that is “out of the box” and contains typical Gantt Chart scaffolding – and the code that is individually written by the developer in specific applications to customize it to his/her needs.
A demo file will be made available for download after the session with all required code
In the final part of the session, Aleksander will present some real life examples of business use for the supplied template file.
Here are several screenshots of different interactive Gantt Charts:
NOTE: As this session will build on techniques demonstrated last year, it is strongly recommended that you watch the YouTube video and try out the demo file from the previous session
Bio:
- Based in Warsaw, Poland
- Active as MS Access programmer since 2005
- Working mostly as software developer in production companies – creating bespoke solutions to solve specific problems or cover very specific business processes.
- Last 5 years working mostly for financial banking company.
- Areas of interest: Using Access in both standard and atypical ways
- Big fan of web browser solutions: HTML+CSS+JavaScript
======================================================================
IMPORTANT NOTE:
All sessions will be recorded and later uploaded to the AccessUserGroups channel on YouTube: AccessUserGroups.org – YouTube.
If you do not wish to be part of the recording, please ensure your webcam and microphone are both switched off.
======================================================================
We are planning to try out Zoom as our meeting application.
Please click the link below to download Zoom, if you don’t already have it.
Get Zoom
To join our meetings, please use the following link or phone number
Join Zoom Meeting
If you are asked:
Meeting ID: 924 3129 5683
Passcode: 661210
Dial by your location:
+1 669 900 9128 US (San Jose)
+1 253 215 8782 US (Tacoma)
+1 301 715 8592 US (Washington DC)
+1 312 626 6799 US (Chicago)
+1 346 248 7799 US (Houston)
+1 646 558 8656 US (New York)
+43 12 535 502 Austria
+32 1579 5132 Belgium
+359 3 257 1633 Bulgaria
+385 1300 0988 Croatia
+420 5 3889 0161 Czech Republic
+45 32 70 12 06 Denmark
+358 9 7252 2471 Finland
+33 1 7037 9729 France
+49 69 7104 9922 Germany
+30 211 198 4488 Greece
+36 1 779 9126 Hungary
+353 1 653 3898 Ireland
+39 069 480 6488 Italy
+352 2786 4277 Luxembourg
+356 2778 1288 Malta
+31 20 241 0288 Netherlands
+48 22 307 3488 Poland
+351 308 810 988 Portugal
+40 31 630 1088 Romania
+421 233 418 515 Slovakia
+386 1600 3102 Slovenia
+34 917 873 431 Spain
+41 43 210 71 08 Switzerland
+46 850 539 728 Sweden
+44 203 481 5240 United Kingdom
+44 208 080 6591 United Kingdom
Meeting ID: 924 3129 5683
Passcode: 661210
Find your local number: https://zoom.us/u/a4d0JdR88