If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Text Box Selection
I have a form that is automatically updated every 3 minutes to reflect any
changes made by multiple users (by use of on-timer event). When this event triggers, the entire text of the first record is selected. Sometimes the user is editing a differant record, and this event occurs, which causes him to over-write the first record by accident. Is there an easier way to update the form other than using on-timer? Is there a way to NOT select ALL the text in the record, so that if the user is typing, the worst would be to append verbiage to a record vice over-write it. Again, thank you in advance. Merry Christmas to all!!! |
#2
|
|||
|
|||
Text Box Selection
Hi John
I am a confuse by this. Why would you want to update a form each 3 mins. Any data entered will be saved into the table anyway. You can spilt the DB front / back end and not allow multile users to enter data on this same record. I may be missunderstand what you are doing -- Buon Natale, Happy Chritmas. Wayne Manchester, England. Scusate,ma il mio Inglese fa schiffo :-) Percio se non ci siamo capiti, mi mandate un messagio e provero di spiegarmi meglio. "Posse John" wrote: I have a form that is automatically updated every 3 minutes to reflect any changes made by multiple users (by use of on-timer event). When this event triggers, the entire text of the first record is selected. Sometimes the user is editing a differant record, and this event occurs, which causes him to over-write the first record by accident. Is there an easier way to update the form other than using on-timer? Is there a way to NOT select ALL the text in the record, so that if the user is typing, the worst would be to append verbiage to a record vice over-write it. Again, thank you in advance. Merry Christmas to all!!! |
#3
|
|||
|
|||
Text Box Selection
I have multiple users that input records to the DB. I want to have all users
see (automatically) what might be added by other users. "Wayne-I-M" wrote: Hi John I am a confuse by this. Why would you want to update a form each 3 mins. Any data entered will be saved into the table anyway. You can spilt the DB front / back end and not allow multile users to enter data on this same record. I may be missunderstand what you are doing -- Buon Natale, Happy Chritmas. Wayne Manchester, England. Scusate,ma il mio Inglese fa schiffo :-) Percio se non ci siamo capiti, mi mandate un messagio e provero di spiegarmi meglio. "Posse John" wrote: I have a form that is automatically updated every 3 minutes to reflect any changes made by multiple users (by use of on-timer event). When this event triggers, the entire text of the first record is selected. Sometimes the user is editing a differant record, and this event occurs, which causes him to over-write the first record by accident. Is there an easier way to update the form other than using on-timer? Is there a way to NOT select ALL the text in the record, so that if the user is typing, the worst would be to append verbiage to a record vice over-write it. Again, thank you in advance. Merry Christmas to all!!! |
#4
|
|||
|
|||
Text Box Selection
I may be wrong but if it were me doing this I would take a simpler route and
refresh the form after the user has done whatever it is they are doing Put some thing like this on each field that users update Private Sub FieldName_AfterUpdate() DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 End Sub This would allow other to see the changes as soon as they have been made -- Buon Natale, Happy Chritmas. Wayne Manchester, England. Scusate,ma il mio Inglese fa schiffo :-) Percio se non ci siamo capiti, mi mandate un messagio e provero di spiegarmi meglio. "Posse John" wrote: I have multiple users that input records to the DB. I want to have all users see (automatically) what might be added by other users. "Wayne-I-M" wrote: Hi John I am a confuse by this. Why would you want to update a form each 3 mins. Any data entered will be saved into the table anyway. You can spilt the DB front / back end and not allow multile users to enter data on this same record. I may be missunderstand what you are doing -- Buon Natale, Happy Chritmas. Wayne Manchester, England. Scusate,ma il mio Inglese fa schiffo :-) Percio se non ci siamo capiti, mi mandate un messagio e provero di spiegarmi meglio. "Posse John" wrote: I have a form that is automatically updated every 3 minutes to reflect any changes made by multiple users (by use of on-timer event). When this event triggers, the entire text of the first record is selected. Sometimes the user is editing a differant record, and this event occurs, which causes him to over-write the first record by accident. Is there an easier way to update the form other than using on-timer? Is there a way to NOT select ALL the text in the record, so that if the user is typing, the worst would be to append verbiage to a record vice over-write it. Again, thank you in advance. Merry Christmas to all!!! |
#5
|
|||
|
|||
Text Box Selection
Would this 'refresh' the form for other users that are at other locations?
"Wayne-I-M" wrote: I may be wrong but if it were me doing this I would take a simpler route and refresh the form after the user has done whatever it is they are doing Put some thing like this on each field that users update Private Sub FieldName_AfterUpdate() DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 End Sub This would allow other to see the changes as soon as they have been made -- Buon Natale, Happy Chritmas. Wayne Manchester, England. Scusate,ma il mio Inglese fa schiffo :-) Percio se non ci siamo capiti, mi mandate un messagio e provero di spiegarmi meglio. "Posse John" wrote: I have multiple users that input records to the DB. I want to have all users see (automatically) what might be added by other users. "Wayne-I-M" wrote: Hi John I am a confuse by this. Why would you want to update a form each 3 mins. Any data entered will be saved into the table anyway. You can spilt the DB front / back end and not allow multile users to enter data on this same record. I may be missunderstand what you are doing -- Buon Natale, Happy Chritmas. Wayne Manchester, England. Scusate,ma il mio Inglese fa schiffo :-) Percio se non ci siamo capiti, mi mandate un messagio e provero di spiegarmi meglio. "Posse John" wrote: I have a form that is automatically updated every 3 minutes to reflect any changes made by multiple users (by use of on-timer event). When this event triggers, the entire text of the first record is selected. Sometimes the user is editing a differant record, and this event occurs, which causes him to over-write the first record by accident. Is there an easier way to update the form other than using on-timer? Is there a way to NOT select ALL the text in the record, so that if the user is typing, the worst would be to append verbiage to a record vice over-write it. Again, thank you in advance. Merry Christmas to all!!! |
#6
|
|||
|
|||
Text Box Selection
No - not if they are looking at the same form - but you should not let this
happen as there may 2 users changing the same record at the same time. Yes - if the form has been set up OK Or you can always requery the base table or query for the form Private Sub FieldName_AfterUpdate() Me.requery End Sub Even though I still can not see the point in any of this as the data will always be saved into the table anyway and so other users -- Buon Natale, Happy Chritmas. Wayne Manchester, England. Scusate,ma il mio Inglese fa schiffo :-) Percio se non ci siamo capiti, mi mandate un messagio e provero di spiegarmi meglio. "Posse John" wrote: Would this 'refresh' the form for other users that are at other locations? "Wayne-I-M" wrote: I may be wrong but if it were me doing this I would take a simpler route and refresh the form after the user has done whatever it is they are doing Put some thing like this on each field that users update Private Sub FieldName_AfterUpdate() DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 End Sub This would allow other to see the changes as soon as they have been made -- Buon Natale, Happy Chritmas. Wayne Manchester, England. Scusate,ma il mio Inglese fa schiffo :-) Percio se non ci siamo capiti, mi mandate un messagio e provero di spiegarmi meglio. "Posse John" wrote: I have multiple users that input records to the DB. I want to have all users see (automatically) what might be added by other users. "Wayne-I-M" wrote: Hi John I am a confuse by this. Why would you want to update a form each 3 mins. Any data entered will be saved into the table anyway. You can spilt the DB front / back end and not allow multile users to enter data on this same record. I may be missunderstand what you are doing -- Buon Natale, Happy Chritmas. Wayne Manchester, England. Scusate,ma il mio Inglese fa schiffo :-) Percio se non ci siamo capiti, mi mandate un messagio e provero di spiegarmi meglio. "Posse John" wrote: I have a form that is automatically updated every 3 minutes to reflect any changes made by multiple users (by use of on-timer event). When this event triggers, the entire text of the first record is selected. Sometimes the user is editing a differant record, and this event occurs, which causes him to over-write the first record by accident. Is there an easier way to update the form other than using on-timer? Is there a way to NOT select ALL the text in the record, so that if the user is typing, the worst would be to append verbiage to a record vice over-write it. Again, thank you in advance. Merry Christmas to all!!! |
#7
|
|||
|
|||
Text Box Selection
Background: I have 3 laboratories, each lab adds records to the DB (comments
of what is going on with the instruments, etc). Each lab 'backsup' or supports the other. Each needs to be aware of changes in the others lab. So each user needs to 'see' the added information as it is entered. I have restricted the changing of entries to that person who made it. So only one person can change an entry, the ones they made. The me.requery in the after_update event would only trigger for the person making the update. The other 2 labs would not see it. "Wayne-I-M" wrote: No - not if they are looking at the same form - but you should not let this happen as there may 2 users changing the same record at the same time. Yes - if the form has been set up OK Or you can always requery the base table or query for the form Private Sub FieldName_AfterUpdate() Me.requery End Sub Even though I still can not see the point in any of this as the data will always be saved into the table anyway and so other users -- Buon Natale, Happy Chritmas. Wayne Manchester, England. Scusate,ma il mio Inglese fa schiffo :-) Percio se non ci siamo capiti, mi mandate un messagio e provero di spiegarmi meglio. "Posse John" wrote: Would this 'refresh' the form for other users that are at other locations? "Wayne-I-M" wrote: I may be wrong but if it were me doing this I would take a simpler route and refresh the form after the user has done whatever it is they are doing Put some thing like this on each field that users update Private Sub FieldName_AfterUpdate() DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 End Sub This would allow other to see the changes as soon as they have been made -- Buon Natale, Happy Chritmas. Wayne Manchester, England. Scusate,ma il mio Inglese fa schiffo :-) Percio se non ci siamo capiti, mi mandate un messagio e provero di spiegarmi meglio. "Posse John" wrote: I have multiple users that input records to the DB. I want to have all users see (automatically) what might be added by other users. "Wayne-I-M" wrote: Hi John I am a confuse by this. Why would you want to update a form each 3 mins. Any data entered will be saved into the table anyway. You can spilt the DB front / back end and not allow multile users to enter data on this same record. I may be missunderstand what you are doing -- Buon Natale, Happy Chritmas. Wayne Manchester, England. Scusate,ma il mio Inglese fa schiffo :-) Percio se non ci siamo capiti, mi mandate un messagio e provero di spiegarmi meglio. "Posse John" wrote: I have a form that is automatically updated every 3 minutes to reflect any changes made by multiple users (by use of on-timer event). When this event triggers, the entire text of the first record is selected. Sometimes the user is editing a differant record, and this event occurs, which causes him to over-write the first record by accident. Is there an easier way to update the form other than using on-timer? Is there a way to NOT select ALL the text in the record, so that if the user is typing, the worst would be to append verbiage to a record vice over-write it. Again, thank you in advance. Merry Christmas to all!!! |
Thread Tools | |
Display Modes | |
|
|