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
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
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)
Recent Comments