Send another user a message?

[rglman]

Is there a way to send another user a message within Access? (Like "Instant Messenger" or Lotus Notes "SameTime") If you have any experience or info I would appreciate some info.
Thanks in advance!

 

[KeithG]

You can send them an email but I don't think you can send them a message thru access.

 

[Uncle Gizmo]

E-mail is probably the best way!

However if you have a front end, back End arrangement then it is possible to have the messages stored in a message table on the back end, and then on the front end database have a hidden form that uses the timer event to interrogate this database periodically to see if there are any new messages. If there are, it pop's up another form showing the message.

I have seen this done, I don't recommend it, it's a bit messy, and it's best to avoid the timeer function within your database.

 

[shepHeard]

If users are accessing accross a network it's possible to use the network message application.. (netsend??)

We used to use this where I worked a few years ago through VB and Excel.

If you can get the user name by code, you can then send them a network message. I know it's possible to get the current user (application.currentuser), but that would be you. Whether it's possible to get a list of connected (to the DB) users I don't know.

I'll try and dig out the code to automate the message sending if you want? (Though I've got to say, it may be too old to work now as it is..)

Hope this helps,

Shep

 

[ghudson]

Net Send works great unless you have Windows XP SP2 installed. SP2 disables the Net Send command.

creating/modifiying net send

pop up message

The Environ() function will help you get the users network ID and computer name which you will need to use the Net Send command.

Searching the forum is a great way to discover and learn the answers to your Access programming questions.

 

[rglman]

Thanks for the suggestions!

Thanks for the suggestions!

I guess I deserved the "send them an e-mail" responses...

 

[gold007eye]

Net Send works great unless you have Windows XP SP2 installed. SP2 disables the Net Send command.

That is not necessarily true. Our company has XP SP2 and netsend works fine across our network. Maybe it is disabled at the administration leve? This also works on my home network as well. I think Net Send would be better than e-mail, because the e-mail method can get complicated; especially if the user doesn't have their e-mail client open.

 

[ghudson]

That is not necessarily true. Our company has XP SP2 and netsend works fine across our network. Maybe it is disabled at the administration leve? This also works on my home network as well. I think Net Send would be better than e-mail, because the e-mail method can get complicated; especially if the user doesn't have their e-mail client open.

By default, Windows XP "SP2" turns off the NetSend command. You [or your company] would have to turn it on after Windows XP SP2 is installed.

The NET SEND command may not work correctly on a computer that is running Windows XP Service Pack 2

 

[gold007eye]

Hmm that is weird.. It works on my home network as well. 7 computers (all with XP S2) and none in which I had to enable.. maybe I got lucky.. lol.

Net Send is great at work when people don't know what it is and you send them a scary message.. lol