UtterAccess Discussion Forums
  UtterAccess Home  | Forums Index  | Search  | Links DB  | FAQs   
Microsoft® Access help forums plus Excel, Word, Outlook®, Visual Basic®, SQL Server®, Office online and... many more!
Forums Index My UA Who's Online Login Become a UA member now! This is free & confidential!

Access UtterAccess!
New? Welcome!
Join UA here!

Members Login


Password


Remember me!


Search The Database
Advanced Search

Google
Web UA

More Links

  UtterAccess Links
  Link to UtterAccess
  Call UtterAccess Home
  Add UA to Favorites

Quick Jump

UA Recommended
Access 2007

Access Team Blog
•  Get the latest information
    directly from the
    Microsoft® Access
    Product Team!

Access Team Blog

Get the latest information directly from the Microsoft® Access Product Team!


UA Recommended
UA's own Grover Park George on Access

UA's own ScottGem and datAdrenaline!

Servers tuned by
Vaultechnology
Send a message to all logged-in users

Send a message to all logged-in users

Posted on 04/23/04 09:05 AM Attachment (1197 downloads)
Posted by adaytay - Utter Access VIP
Posts: 3550 - Loc: Yorkshire, England.

Forum: Access Code Archive 		• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator

• Top of page
Following a good reception in the open forums, I'm posting this in here for you to download and use at your leisure!

Have you ever wished you could quickly get all your users out of the db because you need to do something design-wise in the back-end of the database?

This mini-app could be the answer...

This database (and there's 97 & 2K versions attached) will allow you to create a message which will be displayed to every active user on your database. This could be a "Happy Easter" message... it could be a "Please log out at 3 pm" message... the options are limitless!

All you need to do is:

Drop the table tblSystemMessages into the BE, and link to the FE.
Get the form frmSystemMessageCheck to open HIDDEN when the db opens for the first time. This checks the contents of tblSystemMessages (using DAO, so ensure you check the necessary reference if needed) every 300,000 milliseconds (or 10 minutes) - this can be changed if you like! If there are any new messages, it displays them one by one in a message box.

To create a new message, open the form frmEditSystemMessages and drop your message in there.

If you have any queries or comments, please PM me.

Ad.

Edited by: ghubbell on 04.26.04.

--------------------
Cheers,

Adam
My site :: Coming Soon - ScamWatcher

Page Jump
Pages: 1

Navigate
Post List
Previous thread Previous
Next thread Next

Thread Options & Info
• Threaded
• Print Thread

• 4464 Thread views

Page Jump
Pages: 1
©2009 UtterAccess.com. All rights reserved.    Privacy Policy    UA Cookies    Top

Delivered to you by Shiny New Too Server in 0.021 seconds. 0.004 seconds to process 14 queries. Zlib compression enabled.