sending messages to connected users

[ECUS]

just wondering if it is possible to send a message to connected users of a multiuser database.

the only way i could think of was have a macro or code run every few minutes or so that checks a table. the table could have a yes to print message, and then the text. but this seems kind of silly.

thanks in advance

-ec

 

[MrTibbs]

What circumstances will trigger a message ? Is it an automated 'must happen at 8pm daily' or some set of data ?
If it's a data set put tests on the changing of each element that check all involved elements and trigger the message.
If it's at a time consider using an external scheduler (NT's AT for example) which calls a shell app that reads the list of users and sends the message.
What message transport are you proposing? Do you want to Winpopup or a Msgbox? Will you mail them via a 3rd party mailer?

 

[MrTibbs]

What circumstances will trigger a message ? Is it an automated 'must happen at 8pm daily' or some set of data ?
If it's a data set put tests on the changing of each element that check all involved elements and trigger the message.
If it's at a time consider using an external scheduler (NT's AT for example) which calls a shell app that reads the list of users and sends the message.
What message transport are you proposing? Do you want to Winpopup or a Msgbox? Will you mail them via a 3rd party mailer?

 

[BukHix]

If you are on a Windows NT/Win2k network you can use the net send along with a call shell to get a message to a user or a group of users.

It would look something like this:

Dim strCompName as String
Dim strMessage as String
Dim strNetSend as String

strCompName = "ComputerName " 'Name of computer that gets message.
strMessage = "This seems to be working!" ' Message to send.
strNetSend = strCompName & strMessage ' Puts it all together.

Call Shell("net send " & strNetSend, 1) ' Run the net send command.

[This message has been edited by BukHix (edited 11-14-2001).]

 

[Randomblink]

Curious...could you help me figure out what code you would write that would grab the Computer Name automatically...?
(I just happened to check out this post and find it fascinating...it would be great to grab everyone who is in the database and send them all a message, ie GET OUT OF THE DATABASE!...lol)

 

[BukHix]

Randomblink,

Here is a thread with the code and/or a download to find out who is logged into the database at any time. It grabs the computer name so it would be very easy to use the net send with it.

Topic: Interrogating the LDB.

Let me know if you need help doing the conversion.

 

[ECUS]

hey thanks for all the great responses, i haven't been checking it until now, so sorry for the delay in my response.

the purpose is just what Randomblink mentioned, i.e., i'm going to be working on the database and i need everyone to get out. so it would be run off a command on the switchboard that would only appear when the admin or the like is logged in.
(i guess bukhix answered your question)

i can grab the information but i don't know how to send it. i think a simple msgbox would do, and yeah, i wish everyone was using win2k or nt. unfortunetly there are some 98 boxes accessing the database too.

that netsend is really interesting though, i may use that in part as well, thanks a bunch.

it needs to be within the database, and not a separate e-mail. a timed version of it would be pretty useful to, i.e. at 5, send a reminder to get out while i work on it.
(only for a month or two while i tweak it i guess, as it just got pushed out).