How to make popup message or notification on shared database (1 Viewer)

[Babycat]

Hi everyone,

I am designing an access program that shares BE for multi-users on LAN... I currently dont know how to push a message to specific user.
For example, an inventory user has just made a goods delivery request via his FE into system. At this time, the FE of accountant-user should receive a popup message or * asterisk mark somewhere (similarly to new email notification in outlook) so that the accountant can know the request and have further appropriate actions.

Any advice is highly appreciated

Thank you.

 

[Babycat]

I have found this thread after mine posted...

Solved - Send message to specific user in access multi user based system

I have multiuser access database system, with following highlights. - separate Front end + back end (on network) - more than 30 users. - Different user roles, 3 types. - Use tempvars on each form to records user ID for activity. What I need: how to send message to specific user (as private)...

www.access-programmers.co.uk

Downloaded arnelgp example code, if i am not wrong, it only can check the new msg at the momment of form opening.
So, what if the FE of account-user is already opening?
I am thinking about using timer to check new msg but it might be very distracting and not effective.

Is these any other way to work around?

 

[Minty]

Have a look at this thread in the sample databases.

An Attention Seeking Database

A recent thread https://www.access-programmers.co.uk/forums/showthread.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...

www.access-programmers.co.uk

 

[arnelgp]

I am thinking about using timer to check new msg but it might be very distracting and not effective.

add timer if you need to.

 

[Gasman]

You could also use shell and the MSG command?
That would give a windows popup?

 

[isladogs]

In addition to my Attention Seeking database mentioned by @Minty in post #3, you might be interested in this example Almost Instant Messenger