
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.
[02 Oct 2023] I've been off the grid for a while, due to serious family problems. I can foresee more problems coming - nonetheless a new tool is now available in my online shop. And this time it's FREE. File Manager is an Access class with 28 functions to manipulate files and folders, and even zip/unzip whole folders. Watch a
[28 Feb 2023] One more tutorial, y'all! Would you like to sort your continuous forms by double clicking on a column header? Sorter shows you how to add this feature to your projects in an easy and quick way. Embed the components in your project, configure the included table, and you're set to go. Short preview on my YouTube Channel.
[14 Feb 2023] It took me quite long, but the third workshop in my "MS Access Advanced VBA" is finally ready! Learn how to build a scrollable timeline in Access, and how to place objects on it using the "bitfield" technique. A long workshop split in three chapters, which can be viewed individually on in a sequence, according to your needs/preference. Watch the introductory video on my YouTube channel.
[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! [27 Jan 2023] Another tool made it to my online shop! With Colored Ticker you'll be able to easily create colored progress bars, tickers, selectors, or similar. Watch a demo on my YouTube Channel! [15 Jan 2023] Another tool has reached my online shop! Password Builder Assistant will help your users create a new password which matches the house rules. Watch a demo on my YouTube Channel!
Coming next
I've been invited to talk for the Denver Area Access Group (DAAUG) again, on October 19th. I'll present a selection of my "VBA pills", which you can find on my online shop.
Previously this year
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.
An easy and quick way to sort your continuous forms by double clicking on a column header.
Learn how to build a scrollable timeline in Access, and how to place objects on it using the "bit field" technique. A long workshop split in three chapters. Watch the introductory video on my YouTube channel.
A collection of 28 functions to manage files and folders, and to zip/unzip whole folders.
An animated waiting form inspired by the famous 80's TV series "Supercar".