prompt issue

[gestohlenseele]

I am building a regular Access03 database using visual basic. Is there a code for a function that can create a prompt/msgbox that can tell all active users in the database different things?

 

[CaptainD]

Are you saying you want to create an "instant message" feature inside Access where you can select the person to send it to without the other users seeing the message?

 

[gestohlenseele]

No no...

A prompt that goes to every active user in the database telling them something. Everyone should be able to see it.

 

[Ed2020]

One simple way of doing it is to:

1. Create a messages table containing fields UserID (text), MessageText (text), DateTimeSent (date/time), MessageRead (yes/no).

2. Create a form that is open hidden when the database is launched. Give this a timer event to check the table for new messages delivered to the current user. If a new message is found open a frmReadMessage to display the relevant text.

If you open frmReadMessage as acSystemModal (IIRC) then the form will be displayed on top of anything they are viewing - even if they are not focused on the Access window at the time (it should really be acSystemPopup, rather than acSystemModal).

The timer event shouldn't run too frequently to avoid unnecessary overheads - once every few minutes is plenty.

I have an example that I can share on Monday if you like...

Ed Metcalfe.

Please do not feed the trolls.....

 

[JoeAtWork]

Ed's suggestion is basically the same as the one I proposed in the other thread you started:

http://www.tek-tips.com/viewthread.cfm?qid=1480333&page=1