This example application demonstrates how you can use Access to create popup messages in the system tray notifications area. This is ideal if you want to alert users to issues such as:
•Product support or licence about to expire
•A new version available on the program website
The idea for this project came from a thread at Access World Forums:
The main version check code is contained in the procedure: CheckLatestWebVersion in modFunctions. This ‘reads’ the contents of a specified webpage to a temporary text file and searches it for a specified string from which the web version number is extracted
Click any image to view a larger version ...
ShowBalloonTooltip "INFO - New version available", GetProgramName() & " version " & intWebVer & " is available for download from the " & GetCompanyName() & " website", btWarning
An extra form frmBalloonTooltip is provided so you can test the functionality for yourself:
For further information, see the attached PDF file (zipped)
1. The balloon tooltips code works in both 32-bit and 64-bit Access
2. For the alert to work, you need to ensure you switch on notifications from Access in Windows settings
3. Recent versions of Windows 10 have included the Quiet Hours feature. When this is enabled (normally in evening & overnight), no notifications appear. Switch it off (or in daytime) & they return!
4. The balloon tooltips code is not mine - if anyone recognises it as their own work, please let me know & I will add your details to the code
Click to download: System Tray Alerts (zipped)