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.
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.
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!
[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've been invited to talk for the Denver Area Access Group (DAAUG) again, on June 15th. I'll present a selection of my "VBA pills", which you can find on my online shop.
[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!
[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.
[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!
How about some links?
VBA shop: Last arrivals
[Tutorial] Continuous form Sorter
An easy and quick way to sort your continuous forms by double clicking on a column header.
[Workshop] "Scrollable timeline" with MS Access
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.
[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".