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.
Do you use MS Office at your workplace? Then VBA is the perfect tool to simplify your users' work, increasing their potential and productivity.
In September I'm going to hold the third of the "Advanced Interfaces with MS Access" workshop series. In this workshop we're going to learn how to build a scrollable timeline, and how to put objects on it. Stay tuned!
In the previous workshops we saw how an approximate string matching algorithm can be realized in VBA, and how a drag and drop engine can be applied to images and labels. If you missed them but are interested, please let me know.
How about some links?
VBA shop: Last arrivals
[#Access] Config Table Manager
A class to store, retrieve and delete your users' preferences and configuration items. You will be able to handle preferences per user and/or per machine, as well as multi-value keys (arrays).
[#VBA] API Timers with VBA
Access provides a 'one form-one timer' mechanism. But if we need more timers? Do we have to create an additional form just to 'host' a timer? API timers are a valid alternative which can work not only in Access, but in every VBA-based application.
[#Access] Shaped forms with MS Access
Tired of the usual rectangular forms in Access? Let's learn to how create shaped forms.
[#Access] Webcam in MS Access Free
Do you want to control your webcam in an Access application? You can use a form to project it.