fig', 'UA-9362774-2'); Alessandro Grimaldi | VBA development

My workshops

I am working on a series of workshops to explain in detail the techniques and the code involved in the creation of my graphical interfaces. They all will be available on my Online Shop sooner or later...

Happy Berthday!
Scrollable timeline

In this long workshop we are going to learn how to create a scrollable timeline, and how to put objects on it. This kind of interface can be used whenever there is a need to show a temporal sequence of events: think for example of incoming and outgoing emails, or a set of meetings, or expeditions of goods of any sort, or even incoming and outgoing hotel guests. In this demo clip, this technique is applied to management of ships and ports (UN - WFP Ethiopia, 2010-2011).

During the workshop, the so called bit field technique is going to be explained. Also known as "presence vector", this is an extremely useful technique (one of my favorites, I have to say), which happens to be very useful in many situations.

Given its length and its difficulty, it will probably be split in multiple sessions.

Happy Berthday!
Sliding forms

Here's a variation of the "Drag and Drop" technique. A "sliding forms" effects made with subforms, a valid alternative to the usual "tabbed" control. The forms are fully functional, and you can put all the controls you want on them. A nice graphical effect which allows you to show a large amount of information in a small space. As usual,the code is built from scratch, and every single line is explained and commented in full detail.

Available in my VBA Shop.

Available in my VBA Shop.

VeLo (Vessel Loader)
Drag and Drop with MS Access

Held on 7th July 2021, we learnt how to apply a "drag and drop" effect to images and labels. Lines can also be used to link the draggable objects. This technique and its variations (some of which were explained in these 3 hour workshop) is great to visually show relations among entities, and can be applied to a huge number of situations.

Available in my VBA Shop.

FMIP Geo Module
Approximate String Matching

In this workshop (held on 10th June 2021) we learnt how to implement the so called "Levenshtein Distance" to perform an approximate string search. This technique is particularly useful when you want to perform a search on a set of values using "approximate" search values. This clip shows a possible application (UN - WFP Ethiopia, 2010-2011): searching an Ethiopian location was not easy at all, because of the different transliterations from Amharic. An approximate string search solved the problem, so the users were able to find what they were looking for, without being forced to remember the exact spelling of each location. Note that this is something completely different from the use of jolly characters such as '?' and '*'.

Available in my VBA Shop.

Here's an article about the workshop.