Go Back   Access World Forums > Microsoft Access Reference > Sample Databases

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-02-2017, 04:18 PM   #1
ridders
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 2,063
Thanks: 37
Thanked 483 Times in 448 Posts
ridders will become famous soon enough ridders will become famous soon enough
Create system tray alerts in Access

This database 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 the following thread:
https://www.access-programmers.co.uk...d.php?t=294849

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

The main form in the DEMO database is shown below:



Popup messages similar to these will be displayed in the system tray notifications area





NOTE Screenshots done in Windows 10. Messages look different in earlier Windows versions
===============================================

To use this code with your own databases:

1. Add the VBA reference 'Microsoft Internet Controls'
2. Import and adapt the table tblLocalVariables
Alternatively, adapt the code to use similar data in another table of your own
3. Import all 5 modules
4. Modules modFunctions & modInternetDownload are used for the version check
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
The web version is then compared with the local version number
You will need to ADAPT the code as necessary to suit your own database and website
5. The form also contains a non ActiveX calendar form frmDatePicker which will work in 32-bit or 64-bit Access. The code for this is in modDatePicker
6. The balloon tooltips code is contained in a standard module modBalloonTooltip and a class module BalloonTooltip.
Copy both modules to your project to use this idea

Each message needs a single line of code e.g.

Code:
ShowBalloonTooltip "INFO - New version available", GetProgramName() & " version " & intWebVer 
& " is available for download from the " & GetCompanyName() & " website", btWarning
An extra form frmBalloonTooltip is also provided so you can test the functionality for yourself:

For further information, see the attached PDF file (zipped)
If you have any questions, respond to this thread or send me a PM.

NOTE: the balloon tooltips code doesn't work in 64-bit Access. I will investigate this further at some point in the future
Attached Images
File Type: png MainForm.png (33.1 KB, 507 views)
File Type: png ExpiryDateSoon.png (16.7 KB, 393 views)
File Type: png NewVersionMessage.png (19.4 KB, 388 views)
Attached Files
File Type: accdb SystemTrayAlert.accdb (844.0 KB, 118 views)
File Type: zip Creating System Tray Alerts in Access.zip (834.5 KB, 145 views)

__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
, Tapatalk


If this answer has helped, please click the Thanks button and/or click the 'reputation' scales symbol on the left and leave a comment. Cheers!

Last edited by ridders; 10-17-2017 at 11:04 AM. Reason: Added comment about 64-bit Access
ridders is offline   Reply With Quote
The Following 2 Users Say Thank You to ridders For This Useful Post:
murray83 (08-03-2017), usm01 (08-03-2017)
Reply

Tags
balloon tooltips , system notifications

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access minimized to system tray Novice1 Forms 1 07-10-2015 03:14 AM
System Tray Icon a_20120 Modules & VBA 5 11-28-2013 10:49 AM
Can I disappear my DB to the system tray...? Please? Randomblink Modules & VBA 17 06-30-2006 07:39 AM
minimize to system tray razaqad General 1 03-13-2006 11:18 AM
[SOLVED] Minimize to System Tray syri Modules & VBA 1 10-28-2005 04:49 AM




All times are GMT -8. The time now is 06:32 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World