 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / March 2007HELP! Need Access DB to show realtime changes in different location
Hi Guys, I was wondering about how access refreshes it's data within forms and it seems that it doesn't. If i have a form open in one location on a network and update fields on the form the changes are not shown on the form opened in another location. (I.e. if 2 users are in the same form at the same time and one adds a new record the other users form will not show this change). Is there anyway that Access can be setup to show real-time changes over multiple locations? Preferably without having to do a manual refresh by clicking a button or something. All i want to do is show changes to a form instantly in different locations. Any help would be greatly appreciated. Thanks, Shuja. You can set the form's TimerInterval property to an appropriate time (its value can be between 0 and 65,535 milliseconds), and put code in the forms Timer event to do a requery (using Me.Requery)  SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > Hi Guys, > [quoted text clipped - 19 lines] > > Shuja. > You can set the form's TimerInterval property to an appropriate time (its > value can be between 0 and 65,535 milliseconds), and put code in the forms > Timer event to do a requery (using Me.Requery) Hi Doug, Wouldn't that have the unwanted side-effect of setting the current record as the first in the set? Would Refresh be a better alternative? Regards, Keith. I, too, was under the impression that this was exactly the situation that Refresh was meant to be used for! SignatureThere's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 Interesting thread ... My understanding is that Refresh will cause changes to the current form/record to be displayed (eg. it will refresh calculated controls), whereas Requery will update any changes to the form's recordsource (and, quite likely, change the record being displayed on the form); the Requery will also trigger a refresh for calculated controls. I await further clarification from the experts. Rob > I, too, was under the impression that this was exactly the situation that > Refresh was meant to be used for! from Access 2003 Visual Basic Help: "The Refresh method shows only changes made to records in the current set. Since the Refresh method doesn't actually requery the database, the current set won't include records that have been added or exclude records that have been deleted since the database was last requeried. Nor will it exclude records that no longer satisfy the criteria of the query or filter. To requery the database, use the Requery method. When the record source for a form is requeried, the current set of records will accurately reflect all data in the record source." hth > Interesting thread ... > [quoted text clipped - 9 lines] > > I, too, was under the impression that this was exactly the situation that > > Refresh was meant to be used for! >> You can set the form's TimerInterval property to an appropriate time (its >> value can be between 0 and 65,535 milliseconds), and put code in the [quoted text clipped - 4 lines] > Wouldn't that have the unwanted side-effect of setting the current record > as the first in the set? Would Refresh be a better alternative? A lot depends on what the users want, but I think a Requery is what's required. You can always bookmark the current row, do the requery, then reset the current row based on the bookmark. SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) >> Hi Doug, >> [quoted text clipped - 4 lines] > required. You can always bookmark the current row, do the requery, then > reset the current row based on the bookmark. Duly noted, thanks Doug. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.