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

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-19-2017, 08:43 AM   #1
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 7,376
Thanks: 92
Thanked 1,812 Times in 1,687 Posts
isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light
An Attention Seeking Database

A recent thread https://www.access-programmers.co.uk...d.php?t=295318 prompted me to compile a demo database showing many of the ways of getting users' attention.

Some of the features have already been posted in other threads e.g. in sample databases / code repository
Experienced users will be familiar with many of these ideas already.

Features include various ways of creating messages to get users' attention including:
1. Formatted message boxes
2. Customised message boxes with HTML formatting & countdown timer
3. Flashing, scrolling and balloon tooltip text
4. Dim / blur / remove background
5. Adding warning sounds (use speakers if possible)



NOTE: Some items are meant to be less serious than others!

In addition, I have incorporated a simple 'You have 3 new messages' type feature as described by both CJ_London & Static in the other thread.



The zip file includes images & sounds used by the DEMO database.

Please don't overdo ANY of the more 'overt' methods or you will annoy the users of your databases!

Hopefully the code for each approach is easy to follow.

Any comments, brickbats, questions or issues, please send me a visitor or private message
Attached Images
File Type: jpg MainForm.jpg (47.2 KB, 1526 views)
File Type: jpg UnreadMessagesForm.jpg (15.3 KB, 1486 views)
Attached Files
File Type: zip AttentionSeek.zip (1.34 MB, 596 views)

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
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.
,
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.


Colin
Previously known as ridders : 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.

Last edited by isladogs; 08-19-2017 at 08:51 AM.
isladogs is offline   Reply With Quote
The Following 3 Users Say Thank You to isladogs For This Useful Post:
ashleedawg (08-20-2017), eizik_g (05-24-2018), Eljefegeneo (08-19-2017)
Old 08-28-2017, 12:06 PM   #2
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 7,376
Thanks: 92
Thanked 1,812 Times in 1,687 Posts
isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light
Re: An Attention Seeking Database

I've updated the sample database partly in response to a request from another user in this thread:
https://www.access-programmers.co.uk...d.php?t=295318

Amongst the changes made in v3 are:
1. Added code so the number of unread user messages are now checked/updated at regular intervals - default = 10s

2. Added a button to allow you to add new user messages
NOTE: one new user message is automatically generated each day the db is opened

3. Added additional effects on the 'Add a bit more drama' item including the use of 'Text to Speech'

EDIT
The attached zip file does not include the sounds & images used by the program.
These are part of the zip file attached to the first post
Attached Files
File Type: zip AttentionSeek v3.zip (570.3 KB, 215 views)
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
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.
,
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.


Colin
Previously known as ridders : 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.

Last edited by isladogs; 08-29-2017 at 11:18 AM. Reason: Updated attachment to v3
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
eizik_g (05-24-2018)
Old 09-06-2017, 10:38 AM   #3
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 7,376
Thanks: 92
Thanked 1,812 Times in 1,687 Posts
isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light
An Attention Seeking Database - UPDATED

I've updated this to version 4 so it can also be used in 64-bit Access.
This is in response to a user in this thread:
https://www.access-programmers.co.uk...d.php?t=295617

I've also added an on screen keyboard for any users running Access on a tablet
It has no effect on other machines

NOTE:
The balloon tooltip item currently won't work in 64-bit
I'll come back to this at another time
Attached Files
File Type: zip AttentionSeek.zip (1.35 MB, 240 views)

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
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.
,
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.


Colin
Previously known as ridders : 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.
isladogs is offline   Reply With Quote
The Following 5 Users Say Thank You to isladogs For This Useful Post:
Anticephalous (06-30-2018), bigmac (12-02-2017), eizik_g (05-24-2018), Leshunter (05-11-2018), MrHans (05-24-2018)
Old 12-15-2017, 09:07 AM   #4
murray83
sega collector
 
Join Date: Mar 2017
Location: Daventry, UK
Posts: 359
Thanks: 67
Thanked 0 Times in 0 Posts
murray83 is on a distinguished road
Re: An Attention Seeking Database

this is great why didn't i see this earlier

great work thanks for sharing
murray83 is offline   Reply With Quote
Old 05-23-2018, 04:36 PM   #5
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 7,376
Thanks: 92
Thanked 1,812 Times in 1,687 Posts
isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light
Re: An Attention Seeking Database

Attached is an updated version of this utility

I'm pleased to say, the system tray balloon tooltip alert feature now also works in 64-bit Access.
The only change made is to the class module BalloonTooltip

Many thanks to riti90 for doing the majority of the conversion for this module to 64-bit code
Attached Files
File Type: zip AttentionSeek v5.zip (1.39 MB, 74 views)
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
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.
,
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.


Colin
Previously known as ridders : 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.
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
eizik_g (05-24-2018)
Old 09-10-2018, 02:47 AM   #6
Juleehz
Newly Registered User
 
Join Date: May 2018
Posts: 4
Thanks: 3
Thanked 0 Times in 0 Posts
Juleehz is on a distinguished road
Re: An Attention Seeking Database

Quote:
Originally Posted by ridders View Post
Attached is an updated version of this utility

I'm pleased to say, the system tray balloon tooltip alert feature now also works in 64-bit Access.
The only change made is to the class module BalloonTooltip

Many thanks to riti90 for doing the majority of the conversion for this module to 64-bit code

Need to be approved :c
Juleehz is offline   Reply With Quote
Old 09-12-2018, 08:34 AM   #7
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 7,376
Thanks: 92
Thanked 1,812 Times in 1,687 Posts
isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light
Re: An Attention Seeking Database

Juleehz

Thanks for pointing out that I'd forgotten to approve my own attachment!
It's now FINALLY available for download.

Just a reminder to report your own post to moderated areas as it will significantly speed up the time taken to respond.


__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
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.
,
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.


Colin
Previously known as ridders : 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.
isladogs is offline   Reply With Quote
Reply

Tags
automated user messages , system alerts

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Seeking advice to attempt Vehicle Database Tables (template based) Access2007 Proverbs Tables 27 10-13-2009 05:00 PM
Excel VBA - Need some attention Vader Excel 4 01-19-2007 10:15 AM
Seeking help creating catalog database (text descriptions >255 Char.) fvreg General 5 02-21-2006 10:22 PM
wizcow2 -ATTENTION Vassago General 4 12-14-2003 09:40 AM
attention AXIS need your help..... gino Forms 1 04-04-2000 01:14 PM




All times are GMT -8. The time now is 03:09 PM.


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

Featured Forum post


Sponsored Links


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