asked on

Send Popup message from MS Access to users

Hi everyone!,
I have an MS Access Database as Master Data and there are few access database applications as front end used by few users. (these database tables are linked to main Database master). If I want to edit my main database all other users need to close their applications. So i have to inform them to close applications for a while. Is there any way to send a popup message to those are online (i know who are online, i can get a list). I can send message through email, but i need a popup message through MS Access or a Visual Basic application to send a message through LAN to those who are using my applications (all are using one workgroup file). Appreciate your valuable comments.....
Regards

[ fanpages ]

Hi manchery,

You could call the "NET SEND {name | * | /DOMAIN[:name] | /USERS} message" command via a Shell (or ShellExecute API) call.

For example,

Shell("NET SEND manchery LOG-OFF!")

BFN,

fp.

SOLUTION

[ fanpages ]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

manchery

ASKER

Hi fanpages,
Thanks for your early response. I appreciate if u could explain me more about creating table and query. If I use this option to query every 10 seconds do u think it will disturb the users while it running every 10 seconds?,, pls explain me the way to do, if its not disturbed..
thanks
manchery

manchery

ASKER

hi fanpages, do you mind to use any chat option like yahoo chat, would like to talk with u faster, if u dont mind u can use my yahoo id vm_2000 at yahoo dot com change at and dot ok,, regards

manchery

ASKER

sorry just missed a letter in my id,, its vmj_2000 really sorry

[ fanpages ]

Hi manchery,

Chatting offline would defeat the object of this forum and give me an unfair advantage at answering your query, so sorry, no I cannot do this.

I was proposing that on a MS-Access form that is always loaded you have a timer control that queries the contents of the "Message" table on a regular basis (10 seconds if you wish, longer to suit your organisation's infrastructure and subject to the specification of your end users' workstations, thus avoiding 'disturbance').

If a record if found (i.e. Use a recordset to query with SQL "SELECT * FROM [Message_Table]" and if the Recordset RecordCount is > 0) then display a message to the Application StatusBar.

You could then place messages in the [Message_Table] (or delete a previous message) from the comfort of your own machine.

BFN,

fp.

manchery

ASKER

Thank you boss,
How about if they are not on a specific form. I wish as soon as i send a message they have to see it as a popup. Otherwise email is working ok. the problem with email is if they didnt open their email application (Lotus notes) they wont get the message immediately, it delays our time. Please tell me what is the best option to send them popup message immediately no matter on which form they are. really appreciate ur valuable time and expertise,,,
thanx

[ fanpages ]

Hi fanpages,

As I said previously, you could use

Shell("NET SEND manchery LOG-OFF!")

Or alternatively you could use:

MsgBox("Message")

Or even create a specific form to load just to display the message.

The form I mentioned above would not be shown and would always be loaded.
It is needed for the Timer control and is not for the user to open/close/edit etc.

BFN,

fp.

ASKER CERTIFIED SOLUTION

ahmedbahgat

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ahmedbahgat

sorry fanpages

it seems what Iposted is your idea in full details, the credit goes to you anyway

cheers

manchery

ASKER

Thank you fanpage & ahmedbahgat for your support and expertise. As fanpage provided the idea and ahmedbahqat explained it. so i had split the points to make both of happy.
Thanking you once again.