message service

  • Thread starter Thread starter viren
  • Start date Start date
V

viren

is it possible to create a message and send it to a particular user in
access? if the user is logged on i need a form that pops up saying "new
message" .

thanks
 
Sure, build a table with and have a hidden form on each user's workstation
poll the table every so often for a record with that user's username and the
time within the last period. To "send" a message, open a form bound to that
table and select the username and enter a record for that user at that time.
 
hi Arvin,
i am not too sure what you mean by poll the table. could you please provide
me with an example?


i have created a table with fields msg number, message, user, date , id of
person and message read (checkbox)who has sent the message.

i have created a query based on this table with criteria =curent user()
under the "user" field and "0" under the msg read field, so the only time a
message shows up is when the user is logged in and the message checkbox is
clear.

i have attached this query to the switchboard "on load event".

everytime a user logs in if there is a msg that meets the "user" and "msg
read" criteria then it pops up with a msgbox saying "you have a message"

this works everytime a user logs in and out.

if the user is logged in when i send him a msg , he will recieve the
message only next time he logs in. how do i get the switchboard form to
refresh and find messages for that user when he is logged in?
i have tried me.refresh on the on timer event. it refreshes but doesnt find
the new msg i sent

cheers
 
if the user is logged in when i send him a msg , he will recieve the
message only next time he logs in. how do i get the switchboard form to
refresh and find messages for that user when he is logged in?
i have tried me.refresh on the on timer event. it refreshes but doesnt find
the new msg i sent
Click to expand...

You're on the right track with the Timer event. But Refresh only
updates records that already exist in the form's recordset. You want
to check for new records. Try Me.Requery instead.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
Back
Top