Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Message Every User
Liam Convey 
   
4 years ago
I have a task list where all users update and one user will complete the tasks. Is there a way to notify the user when the task has been completed. I could run a timed process every second to see if any updates have been made but this seems a bit clunky, maybe I'm over thinking it? I'd know to filter it to individual users it's more making the after update event run on a separate front end.

Thanks, Liam.
Scott Axton  @Reply  
        
4 years ago
Check out the Record Locks video - especially the Extended Cut.

Thinking out loud here.
I'm thinking that you could modify this to look at a value in a "system field".  If the field value = "InUse" then make the Main Menu background color change.

I'm guessing that you want to basically shut down any interaction while your task is running.  That way if someone doesn't know you are doing a task the color would inform them.  There are a bunch of possibilities.

More info is probably needed to know what you are doing.  You description is a but vague.
Liam Convey OP  @Reply  
   
4 years ago
Hi Scott, that's fair.
Quite simply we have a continuous form that displays all tasks for today. This is added to throughout the day, once complete the employee completing the task will click the "Complete" command button, this will requery the form and the record will turn green. Currently the only way to see if your task has been completed is to check the list repeatedly. I want to make it so that when the technician downstairs clicks complete, a message box will appear on the screen of the user who requested it. Meaning they won't have to keep checking the list to see if their task is green yet.
Scott Axton  @Reply  
        
4 years ago

Ahhh...
In that case I would point you to the Reminder Popup videos as well.  When your tech checks complete it would activate the popup so that the box could appear.  If you want only the person whose task is applicable to see the popup you would need to modify the routine so whether want to see all tasks or only each individuals tasks.

Liam Convey OP  @Reply  
   
4 years ago
Ahh, I don't think I access to that video but from the description I feel it's alluding to what I said earlier. Set a timer event to check  every second for whether the record has been updated or not (I want it to be instantaneous). I wanted to see if there was a "prettier" way of doing it. My brain tells me running the event every single second would do something to the computer's memory.

Thanks for your help Scott.
Kevin Robertson  @Reply  
          
4 years ago
You could use an AfterUpdate Event in an isCompleted Check Box. If the value is True display the message (or however else you wish to notify other users).
Scott Axton  @Reply  
        
4 years ago
Yeah - I wouldn't run a timer every second.  I would probably look at once a minute or even longer.

Timer events don't take tons of clock cycles but depending on how many timers you have going it could impact the performance of your database.  Today's computers can usually handle a pretty significant load.

I missed that you are not a TechHelp member.  I just saw the Developer status and the MYOLP.

You can still watch the free videos in both of the links I provided though the real benefit is in the extended cuts.
Maybe this could convince you to join!  LOL  The price of a cup of coffee at the favorite barista is well worth the extra value you receive.  My take is give it a shot.  If you discover it isn't for you then it is easy to cancel.  

Check out the Access Index and fun some "Searches"  (Ctrl-F)  things like Reminder, Notification, Popup, etc.  There is a lot of things that would help you out from the courses.
Scott Axton  @Reply  
        
4 years ago
Push notifications would be more difficult than a timer checking if there is a record there.
Quite honestly I have never done a Push Notification.  All my experience has been working with something like the reminders.
Kevin Yip  @Reply  
     
4 years ago
Hi Liam, if you need (near-)instant notifications, consider sending text messages to the users.  They can see them on their smartphones, so they won't even need to be at their computers.  Richard has a free video on it: https://599cd.com/blog/display-article.asp?ID=1806 .

You can also send emails to your users from Access (Richard's video: https://599cd.com/blog/display-article.asp?ID=1703 ).  But emails are often not instantaneous as any email user has noticed.
Kevin Robertson  @Reply  
          
4 years ago
This video may also be of use to you.

Sync Remote Database
Liam Convey OP  @Reply  
   
4 years ago
Thank you all for your help. I have plenty of options to choose from now. I feel I know the answer is no but maybe I'm a tad clueless to it. The After Update event is only triggered on that computer isn't it? Everyone has their own front end, if I were to update my form the After Update would be triggered but the other front ends won't see that a change has been made and then trigger themselves will they?
Adam Schwanz  @Reply  
           
4 years ago
Correct, they will not. You will need to update their front end as well. Strongly suggest looking into Access Updater that thing has saved me COUNTLESS hours
Scott Axton  @Reply  
        
4 years ago
I think I need to clarify a bit.  The updater that Adam is speaking about is to update the front end with any code changes that you do.  That wouldn't necessarily update the other users if the status of a task is changed.

You could have the tech update when they have completed the task but that won't necessarily let the person on another computer know that the task is complete.  The only way I can think of right off hand is have each computer checking for completed tasks then pop up a message when one is found.  Again, the timer option to check status of the ticket.

The other option would be to follow Kevin Yips' idea of texting when a task is done.  
Both solutions would have their pros and cons.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/1/2026 10:30:34 PM. PLT: 0s