IM requery event to play sound

  • Thread starter Thread starter Maarkr
  • Start date Start date
M

Maarkr

Hope this makes sense... I have a form that is used by many users, each with
a different front end, used as an instant messenger. Each user has a combo
field to identify themselves, then a message field to type a message, and a
RequestAcknowledge field if they want to get a receipt ack from the
recipient. It works well, and requeries every minute, but I was asked to
play a sound when a message is entered with a ReqAck user so they know they
have a new message. I found a good 'playsound' function that works well if I
use it in my AfterUpdate event where the User (myself)=ReqAck (myself), but
it won't play the sound on another user's machine to let them know they
received a ReqAck message. I understand that the AfterUpdate event only
works if the user updates the combo, so WHAT event or fix do I use to get the
other user's machine to play the sound after the refresh when their User
field = ReqAck field? What event is triggered by a requery of the data on
another user's machine to fire the function and make it sound off?
 
Never mind...I figure this junk out after I post the question...I suppose it
makes my mind clearer... I tied the function to the first field on the form
and the On Got Focus Event. Works OK cause it plays the sound on every
refresh until they AckRec.
 
Back
Top