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!!!

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!!!

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!!!

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!!!

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!!!

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!!!

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!!!