Results 1 to 6 of 6
  1. #1
    mainerain is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Location
    Maine, USA
    Posts
    146

    Refresh all Users

    I have multiple users with their own local copy of the Front End file. On the main form there is an open report that reflects events the technicians have been entering. If a new event is entered it is only visible to the PC that made the change. The other users have to refresh on their own in order to see the new event that was posted. Is there a way to update all users at the time a new event is entered from any PC?



    Thanks

  2. #2
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,803
    If there was, it would be ill advised. Imagine being in the middle of data entry, only to have it get committed as is, or worse, be lost. You probably need to explain the user's process. It may be as simple as using Requery method whenever a user updates their data entry forms.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    Event has a special meaning in Access. I think you are describing "a new record saved into a table".
    As micron advised, more details of the process(es) involved, and the need for "latest info" would help put your post into context.

  4. #4
    mainerain is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Location
    Maine, USA
    Posts
    146
    Quote Originally Posted by Micron View Post
    If there was, it would be ill advised. Imagine being in the middle of data entry, only to have it get committed as is, or worse, be lost. You probably need to explain the user's process. It may be as simple as using Requery method whenever a user updates their data entry forms.
    Point well taken. Thanks

  5. #5
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,803
    there is an open report that reflects events the technicians have been entering
    I interpreted event(s) in the context of some activity that takes place. I think it's pretty safe to say that is what was meant, but I've been wrong before.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  6. #6
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,115
    You could try to use the Timer event of the main form to requery the "open report" (should be a subform?) at certain intervals.
    https://accessdatabasetutorial.com/m...n-timer-event/
    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 02-15-2018, 03:11 AM
  2. Subform refresh
    By Ruegen in forum Forms
    Replies: 13
    Last Post: 08-10-2013, 03:05 AM
  3. How to refresh a DB?
    By adacpt in forum Programming
    Replies: 1
    Last Post: 12-02-2012, 02:45 PM
  4. Refresh All
    By gg80 in forum Programming
    Replies: 3
    Last Post: 01-12-2012, 03:39 PM
  5. Access 2010 Refresh VS Refresh ALL
    By Snwboarder1982 in forum Access
    Replies: 1
    Last Post: 09-09-2011, 04:07 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums