Visual basic help

[gestohlenseele]

Hello,

First post!

I am building a database using Access03 with visual basic. I need to know if its possible to create a button or function that can send a prompt/msgbox to all active users in the database?

 

[Andrzejek]

Can you do it 'by hand'?

If you run on NT and have your messaging on, from command prompt you can say:

C:\> Net Send UserName MessageText
[green]'or[/green]
C:\> Net Send MechineName MessageText

So if you have a place in your data base where you keep track of all the 'active users', then it is no problem to send a message like that to multiple people:

Dim RetVal As Long
RetVal = Shell("Net Send [b]gestohlenseele[/b] [blue]This is your message[/blue]", 0)

Have fun.

---- Andy

 

[JoeAtWork]

Just have a "Messages" table in your database, which is periodically checked by the front-end. When it discovers a new message in the table, it displays it to the user.