Send User Message

[Guest]

Hi all

I want to send users logged in to my Access db a message asking them to
logout. I have developed a routine which logs users in and out of the system
and I have a query 'qry Users' which lists all users still logged in
(loggedoutTime IsNull). This uses fOSUserName as I do not use Access user
security.

I have a form with a textbox 'txtMsg' that I will type in the message and
when I press a Send button I want to display this on each users machine. How
do I get this to appear on other users machines when they all use a different
copy of the front end from me.

Thanks in advance for any help.
Sue

 

[Stefan Hoffmann]

hi Sue,

How
do I get this to appear on other users machines when they all use a different
copy of the front end from me.

Use a table in the backend, e.g. Logout(UserName, Message). In the
frontend use a hidden form with a timer to requery this table.


mfG
--> stefan <--

 

[Guest]

--
Thanks in advance for any help.
Sue

hi Sue,

Use a table in the backend, e.g. Logout(UserName, Message). In the
frontend use a hidden form with a timer to requery this table.


mfG
--> stefan <--

 

[Stefan Hoffmann]

hi Sue,

was this a short and quick "thank you" or have you hit the send button
to fast?


mfG
--> stefan <--

 

[Guest]

Sorry Stefan, I did actually type a nice long reply but when I tried to post
I got a website server error page and when I hit retry it sent a blank msg! I
lost all the text I typed but I needed to leave the office so I did not have
time to type again.

My coding is very basic and not familiar with the timer event but I have
seen a similar post so I will have a read of this. I've also seen a post
where someone has utilised the Net send command. We use terminal services so
this won't work but Msg will via a dos cmd line. I was thinking of maybe
using this instead if it will work? Not sure how to send to all the people
using my query though for the list of names to send to.

Thanks in advance for any help.
Sue

 

[Stefan Hoffmann]

hi Sue,

My coding is very basic and not familiar with the timer event but I have
seen a similar post so I will have a read of this.

See

http://ste5an.de/mpam-logout.zip



mfG
--> stefan <--

 

[Guest]

Thanks Stefan! Will have a look at and come back if I have further questions.

Sue