Decomposing your Access application into external files can be useful for external process automation of source code, version control, or disaster recovery. An Access application is composed of objects of different nature, like forms, reports, queries, macros, code and class modules. Hopefully, you’re already splitting your solutions in separated databases. This for a good reason,… Continue reading How to decompose your Access application into files
Category: Software
How to darken or lighten an RGB color in VB/A
Generate a light or dark color shade from an RGB color value. The ShadeColor() function takes an RGB color value (a Long) and applies a shading algorithm, converting to HSV to darken or lighten the color, then back to RGB to use it in VB/A. Download sample Access database with the code.Then open the frmShadeTest… Continue reading How to darken or lighten an RGB color in VB/A
How to validate an IBAN code with VB/A
Bank accounts are identified with a standardized IBAN code that simplifies international transactions. The code identifies the country, the banking institution and a customer account. You’ll find a function to validate an international Bank account IBAN identifier with VB/A in this post, along with a bunch of test IBANs. There’s a “checksum” contained in the… Continue reading How to validate an IBAN code with VB/A
How to reverse a string in VB/A
There are many ways to do a simple string inversion, character by character, with VB/A. This function uses the Mid$ keyword as a function and as a statement to do it.
Explaining the real time device detector Access demo database
In this post, we’ll examine and explain how the Access application that demonstrates a possible, real life use case, of the device detection feature of the AxDeviceDetector ActiveX server. See the downloads section below to download a copy of the database. Scenario We want to allow, let’s say, restaurant waiters or employees, to register their… Continue reading Explaining the real time device detector Access demo database
Explaining how to detect device arrival/removal in an ActiveX server in real time
We’ve seen know how to get some useful information (like vendor ID and serial number) from attached Windows devices, using a C DLL. Interfacing the DLL with Visual Basic, was then just a matter of declaring the DLL functions in a standard module. With some more basic wrapping, we’ve obtained a simple API function and… Continue reading Explaining how to detect device arrival/removal in an ActiveX server in real time
How to get useful Windows device information in VBA
Here are (at least) 3 properties of hardware like hard disks (whether they are HDD, SSD, USB or else), printers or anything else that Windows considers a device. These can be very useful to obtain in applications that manage enterprise assets like data and documents: Vendor name, Vendor ID, and serial number. These hardware properties… Continue reading How to get useful Windows device information in VBA
How to detect windows session lock/unlock in VBA
There are (at least) 3 solutions to detect when a user locks his/her workstation on Windows and react on the event. A light and efficient solution using Classic Visual Basic (here VB5). A very bad solution in VBA, which involves subclassing and using the Windows API directly. An hybrid solution for an Access (VBA) application,… Continue reading How to detect windows session lock/unlock in VBA
How to implement a circular queue in VBA (Excel)
Temporal modules Queues are part of the “temporal modules” family, with stacks and general double ended queues. They are containers that follow the FIFO (first in, first out) principle for storing and retrieving elements. While stacks follow the LIFO (last in, first out) principle, and general double ended queues can store and retrieve elements in… Continue reading How to implement a circular queue in VBA (Excel)
How to round a number to a five cents multiple in VB/A
In switzerland, we like rounding monetary numbers to 2 decimal places, with multiples of 5 for the fractional part. This is (probably) because our (physical) money has no “cent” coins, but we have 5 cents coins. That’s commonly called “5 cents” rounding. Example: 1.6777777 becomes 1.70 1.4444444 becomes 1.45 1.0333333 becomes 1.05 and so on.… Continue reading How to round a number to a five cents multiple in VB/A