Access programming is inherently single-threaded. That’s usually OK as most operations are sequential anyway and it keeps things simple at the programming level. There are times though where the lack of ability to run code on another thread is sorely missing: anything that takes a long time to run will just freeze the application, making... » read more
This project provides a custom and enhanced message box replacement for the default `MsgBox`found in Access. A Test database containing all the code for Access 2007/2010/2013 is available at the bottom of this post. (__UPDATED Saturday 21OCT2014 to VERSION 1.10.__) ###What’s wrong with the default MsgBox### The default message box in Access is sometimes useful... » read more
In my previous article about changing the MS Access colour scheme I had the need to allow the user to restart the database after the colour scheme was changed. (__Article and Code Updated 13FEB2009.__) Being able to cleanly restart and compact the application is also useful in other instances: * Changes made to the environment... » read more
Microsoft Office 2007/2010 comes with 3 colour (color) schemes. Users can easily change it but when you deploy an Access application under the [Runtime][runtime] your users have no way to set the colour scheme as the application’s options are not available. (__Article and Code Updated 01DEC2014.__) Luckily for us, the global colour scheme setting in... » read more
Microsoft Access Team made an interesting post and a follow-up on how to add a transparent layer that cover the screen to focus the attention of the user to a login form or other important popup window. The trick is to use some WIN 32 API calls to modify the transparency of a standard MS... » read more