Hints, ideas, tips, tricks, unusual code. Visit the shop to download free VBA samples, but also tutorials about useful and interesting topics, and tools to embed in your projects.
Developer since 1982, I met VBA in 1998, and since then it's become my favorite programming language.
Often underestimated, VBA is a powerful tool allowing extraordinary results, especially to automate long, tedious and repetitive tasks, but also to create complex, corporate-level applications.
Do you use MS Office at your workplace? Then VBA is the perfect tool to simplify your users' work, increasing their potential and productivity.
[31 Jan 2023] Another tool has joined my online shop! With Sliding Ticker you'll be able to easily create colored ticker bars. The labels act as sliders, so users can drag and drop them to make their selection. An unusual alternative to more common text boxes and spin buttons. Watch a demo on my YouTube Channel!
[8 Sep 2022] I spoke at the Europe Access User Group webinar, on October 5th. I showed a tool I made for the European Central bank a few years ago, to classify and search Outlook emails. A "filter builder" is implemented, able to create flexible and reusable queries to select emails matching specific criteria. Join our Group!
[27 Sep 2022] Invited to talk at the Lunchtime Access User Group webinar, I spoke about how to implement "Text-To-Speech" in MS Access, showing a simple class to make Access read a text box aloud.
[25 Apr 2022] Another tool has reached my online shop! LOCKER will protect your Access files hiding all that can be hidden, and blocking all that can be blocked. It also converts your .accdb file into an .accde to protect your code. Not a bullet proof protection, of course (we're talking about Access!), but it gives you the top protection that Access allows. Watch a demo on my YouTube Channel!
[10 Mar 2022] New tutorial available: Record pagination with Access. In this tutorial I'll show you how to implement a web-like record pagination, an alternative to the usual continuous forms. The big advantage is that you can design and customize the form as you like, without being limited by the... "continuity" of a continuous form, which often makes it difficult to take actions and customize controls on a "per record" basis.
[10 Mar 2022] Another difficult year, but at least I'm having some satisfaction: I've been appointed co-Chairman of the Europe Access Users Group (see links on the right).
I'm a bit late for the third of my "Advanced Interfaces with MS Access" workshop series, about how to create a scrollable timeline. I'm working hard on other projects and... well, there are only 24 hours in a day! Sorry for that. Please be patient.
[28 Feb 2022] Another workshop just joined my VBA shop. It's a variation of the "Drag and Drop" technique I showed in my previous workshop. This "sliding forms" effect can effectively replace the usual "tabbed" control, but the "tabs" (in this case, subforms) can be shown, at least partially, at the same time. An efficient way to show a large amount of information in a small space. Visit my shop for more ideas, workshops, tutorials, and more!
[29 Jan 2022] Another tool has made it to my online shop! Easily select a range of dates simply dragging two sliders. You can replace the sample graphics to match your application look and feel. Includes an exhaustive User Manual. See it in action!
[7 Jul 2021] It took me some time, but finally the first workshop of my "Advanced Interfaces with MS Access" series is available in my shop. Drag and Drop with MS Access!
Spice up your MS Access applications with graphical, interactive interfaces! In one and half hour this workshop will show you how to add interaction and movement to your Access databases, building a drag and drop engine you can embed in your Access projects. The code is built from scratch, and every single line is explained and commented in full detail.
How about some links?
VBA shop: Last arrivals
[Tutorial] Record pagination
In this tutorial I'll show you how to implement a web-like record pagination, an alternative to the usual continuous forms. The big advantage is that you can design and customize the form as you like, without being limited by the... "continuity" of a continuous form, which often makes it difficult to take actions and customize controls on a "per record" basis.
[Workshop] "Sliding windows" effect with MS Access
A "sliding windows" effect using several MS Access forms: an unusual interface to show a lot of information on a small space. A valid alternative to the usual "tabbed" control.
[Tool] Sliding Ticker for MS Access
Sliding Ticker is a tool to create colored ticker bars using labels as sliders, easy to customize and use.
[VBA Pill] "Supercar" waiting formFree
An animated waiting form inspired by the famous 80's TV series "Supercar".