Broadcast Message

[DHSBob]

Is it possible to send a broadcast message through Access to anyone that
currently has open a specific access program?

 

[Bill Mosca]

I've done that using a hidden form. It has a timer event that checks the
value in a field in a Back End table. The table also has a field for the
message. If the first field's value is 0 nothing happens. If I update that
field to 1 the hidden form shows itself. It has the message field.

If you would like to see a sample, join my Yahoo group (in my signature) and
go to the files>Utilities and Add-ins folder. Download ShowUsers. It
contains everything including a admin form that shows who is in the
database, a button to lock out new users, a button to launch the
announcement form.

 

[Arvin Meyer [MVP]]

Is it possible to send a broadcast message through Access to anyone that
currently has open a specific access program?

Yes, but you need to pull it instead of push it. The easiest way is to
design a form which is linked to a 1 record table on the server. Then have
the form requery every 30 seconds to a minute using the form's Timer event
and TimerInterval property. You can save messages (multiple records) by
allowing a new button and adding a query which sorts the record id
(autonumber) descending.