• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1825
  • Last Modified:

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
0
manchery
Asked:
manchery
  • 5
  • 4
  • 2
2 Solutions
 
[ fanpages ]IT Services ConsultantCommented:
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.
0
 
[ fanpages ]IT Services ConsultantCommented:
Hi again,

...or perhaps create a "Message" table in your application that is queried every 10 seconds or so.

If it contains a record, then this is displayed on the Application StatusBar of MS-Access.

BFN,

fp.
0
 
mancheryAuthor Commented:
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
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
mancheryAuthor Commented:
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
0
 
mancheryAuthor Commented:
sorry just missed a letter in my id,, its vmj_2000 really sorry
0
 
[ fanpages ]IT Services ConsultantCommented:
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.
0
 
mancheryAuthor Commented:
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
0
 
[ fanpages ]IT Services ConsultantCommented:
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.
0
 
ahmedbahgatCommented:
you may try this,

backend work:

1. create a table in the backend and call it "WarnUsers" for exampe
2. the table will have only one field, let's call it "Activate"
3. the field data type will be yes/no  ie either 0 for No, -1 for Yes
4. add a record to that table and the data should be No  ie 0

frontend work:

1. Link the frontend to the new table
2. create a function in a global module, that will represent the warninig message ie:

Function Warning()
  Beep
  MsgBox "You must exit the application within a minute for an urgent update", 16, "Warning"
End Function

3. create a form "Warningfrm", a tiny and empty one with no objects in there, this form should be opened hidden when the users start their frontend, ie it will be running all times, but the users do not see it, this can be achieved using the following command:

DoCmd.OpenForm "Warningfrm", , , , , acHidden

4. this form will have some code in the OnTimer event:

Dim Rs As RecordSet
Set Rs = CurrentDB.OpenRecodSet("SELECT WarnUsers.* FROM WarnUsers;")
If Rs!Activate = -1 Then
    Warning
End If
Rs.Close

5. make the Timer Interval = 10000 which is about 3 seconds

to warn all users, you open the backend, open the table we created and change the field data from 0 to -1, this will force the message to popup every 10 seconds "pretty annoying and they have to close access


my final note will be there will be an overhead regarding OnTimer event for the hidden form but I believe it will be minute as the table will always include 1 field and 1 record, that is 0 or -1, the simplest thing a computer can recognise, you can tell us on the effect

cheers
0
 
ahmedbahgatCommented:
sorry fanpages

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

cheers
0
 
mancheryAuthor Commented:
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.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now