How do I replace just a part of text in a memo field by value in a

  • Thread starter Earl.AKA J.Alladien in access forum!!
  • Start date
E

Earl.AKA J.Alladien in access forum!!

Hi all,

How do I do a replace/Update qry where just a certain part of text in a memo
field gets replaced by a value in another field from the same table fe:

Name e-mail
message(memo field)

marco wongso (e-mail address removed) "DEAR #NAME#,

U ARE THE BEST!
*becomes*
marco wongso (e-mail address removed) "DEAR marco wongso,

U ARE THE BEST!


Mikal Jordan (e-mail address removed) "DEAR #NAME#,

U ARE THE BEST!
*becomes*
Mikal Jordan (e-mail address removed) "DEAR Mikal Jordan,

U ARE THE BEST!


Is this possible?Please advise and thanks in advance!
 
J

John Spencer

If you are using a Version of Access that supports it you can use the
VBA replace function. Look it up in VBA help

Field: InsertName: Replace([Message],"#NAME#",[Name])

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
E

Earl.AKA J.Alladien in access forum!!

Works perfect John,

Thanks a lot!

John Spencer said:
If you are using a Version of Access that supports it you can use the
VBA replace function. Look it up in VBA help

Field: InsertName: Replace([Message],"#NAME#",[Name])

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================


Earl.AKA J.Alladien in access forum!! said:
Hi all,

How do I do a replace/Update qry where just a certain part of text in a memo
field gets replaced by a value in another field from the same table fe:

Name e-mail
message(memo field)

marco wongso (e-mail address removed) "DEAR #NAME#,

U ARE THE BEST!
*becomes*
marco wongso (e-mail address removed) "DEAR marco wongso,

U ARE THE BEST!


Mikal Jordan (e-mail address removed) "DEAR #NAME#,

U ARE THE BEST!
*becomes*
Mikal Jordan (e-mail address removed) "DEAR Mikal Jordan,

U ARE THE BEST!


Is this possible?Please advise and thanks in advance!
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change the color of each capital letter in a rich text memo field. 0
Replace Text in a memo field 4
Memo field is automatically changing to text field in count query 3
text length in a text box versus memo field 2
Replace a specific character in the memo field 1
How do I disable highlight of locked memo field? 4
can I extract part of a 'memo' field into a 'text' field? 1
What is the box character in a text field and how do I replace it? 2

Top