VBA on sale
Code, tutorials, ideas, hints and tips about VBA
Skip to content
Click on an item for more details
Elliptical splash form
How to create en elliptical splash screen in Access
Two tricks for a VBA class: default method and collection enumeration
Automatic table relinking
An easy way to automatically relink tables in our front end, when we have to move it back and forth between different locations (e.g. Development and Production)
API declaration: 64 vs 32 bit
Confused about 32/64 bits, and how to declare API functions? Learn how to correctly write your code, using <PtrSafe> and the conditional compilation directives.
Easy front end deployment
A simple, quick and safe deployment method for your Access front ends.
Shaped forms with MS Access
How to create non-rectangular forms in MS Access.
How to create multiple API timers, as an alternative to the "one form-one timer" mechanism provided by MS Access.
VBA References and Binding
A discussion about VBA references, and the main pros and cons of early binding vs. late binding. An Access file is made available, exposing information about the main libraries.
Last record ID
When you share a backend with many users, retrieving the last added record ID may be tricky. This tutorial provides an easy solution.
Popup menus with Access
How to build multi-level, popup menus with Access. Includes a function to show all the available <.faceID> values.
How to implement a web-like record pagination with MS Access: an alternative to the usual continuous forms.