How to decompose your Access application into files

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

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