Message (1 Viewer)

[Gismo]

Hi all,

Is it possible to send a message to all users signed in to a specific DB, also to have the message pop up then a user signs in.

I suppose it could be as simple as to write the message into a table and repeat it for all active users
Not sure how to have the message pop up once sent to all users

 

[arnelgp]

you need a Hidden form on the startup of your db that check
your msg table for New msg.
also you can have timer event on this hidden form to check
every once in a while for new msg.

 

[bastanu]

Have a look at my free custom chat utility:

FBA MS Access Custom Chat - ForestByteApps

ForestByteApps - A place for Microsoft Access code samples and utilities to make your life easier. Free Microsoft Access tools and sample VBA code

forestbyte.com

Cheers,

 

[Pat Hartman]

eMail works. If you have an IM program, you might be able to use that also.

 

[The_Doc_Man]

Is it possible to send a message to all users signed in to a specific DB, also to have the message pop up then a user signs in.

The answer is a qualified "NO." The answer is because Windows, in compliance to U.S. Government rules about process/task independence, does not allow a process to interfere with another process or user or system. The pop-up would be disallowed.

It's a QUALIFIED "NO" because there is a loophole. IF you built a technique into each copy of the front end file to LOOK FOR information related to a message, then each FE can pop up the message itself.

The general way to do this is a "messages pending" table and have a "messenger" form in each FE with a timer to check for new messages. Beyond that, the possible details are so many as to defy description.

 

[bastanu]

That is exactly how my utility works...

Cheers,

 

[The_Doc_Man]

So I gave you the theory of what to do and Vlad gives you a sample. Teamwork. Thanks, Vlad!