Text box Update

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hallo

I hope some one can help me I want to do the following adding new text to an
already existing text box

Ok this is what i have a database with a list of user and there access the
access that they have are in a text box field and i have a intranet site
where the can request new access but what it does it will add a new record
but i want it to update the old record instead of a new one that's no problem
but this one text box already has info in it which is not allowed to be
overwritten the new access just need to be added to the end of text box does
any one have a idea how I can do this

Regards
Markus
 
Hallo

I hope some one can help me I want to do the following adding new text to an
already existing text box

Ok this is what i have a database with a list of user and there access the
access that they have are in a text box field and i have a intranet site
where the can request new access but what it does it will add a new record
but i want it to update the old record instead of a new one that's no problem
but this one text box already has info in it which is not allowed to be
overwritten the new access just need to be added to the end of text box does
any one have a idea how I can do this

Regards
Markus
Click to expand...

The best way would be to add an additional record. If you must use
the same record, copy the contents of the field to a variable prior to
editing. Start with clear textbox; when done adding the new message,
add back the original contents from the saved variable prior to
the .update.
For example:
strMessage=txtMessage
With tblLog
.Edit
!Message=strMessage & vbcrlf & !Message
.Update
End With
 
Back
Top