Hi Guys,

I have two fields (fldName & fldComments), how can I insert the value of
fldName inside fldComments (Memo Field)?

E.g.

fldName = George
fldComments = Thank you fldName for attending the seminar.

Output = Thank you George for attending the seminar.


Cheers,
George

George,

<< I have two fields (fldName & fldComments), how can I insert the value of
fldName inside fldComments (Memo Field)?

E.g.

fldName = George
fldComments = Thank you fldName for attending the seminar.

Output = Thank you George for attending the seminar. >>

First, George, I have to do my "civic duty"... heh, heh.  Namely, it's not 
good practice to store "calculated fields".  That is, if your comments are 
always going to be "Thank you, [fldName], for attending the seminar," then 
you should calculate it on the fly each time.  Storing calculated fields 
takes up valuable computer memory real estate.

OK, so suppose you have a good reason to store that memo field.  Then your 
request is not hard.  Assuming the fldComments is always initialized 
to "Thank you, fldName, for attending the seminar.":

(Note above the commas before and after the fldName to be grammitcally 
correct.)

   Me.fldComments = Left(Me.fldComments, 11) & Me.fldName & _
   Mid(Me.fldComments, 12, Len(Me.fldComments))

If fldComments is not intialized then:

   Me.fldComments = "Thank you, " & fldName & _
   ", for attending the seminar."

Gregory,
Thanks for the reply, but my fldComments is not fixed.
I need this option for my email solution, means that
fldComments is my Email Body.

George


--- Gregory Serrano <SerranoG@m...> wrote:
> George,
> 
> << I have two fields (fldName & fldComments), how
> can I insert the value of
> fldName inside fldComments (Memo Field)?
> 
> E.g.
> 
> fldName = George
> fldComments = Thank you fldName for attending the
> seminar.
> 
> Output = Thank you George for attending the seminar.
> >>
> 
> First, George, I have to do my "civic duty"... heh,
> heh.  Namely, it's not 
> good practice to store "calculated fields".  That
> is, if your comments are 
> always going to be "Thank you, [fldName], for
> attending the seminar," then 
> you should calculate it on the fly each time. 
> Storing calculated fields 
> takes up valuable computer memory real estate.
> 
> OK, so suppose you have a good reason to store that
> memo field.  Then your 
> request is not hard.  Assuming the fldComments is
> always initialized 
> to "Thank you, fldName, for attending the seminar.":
> 
> (Note above the commas before and after the fldName
> to be grammitcally 
> correct.)
> 
>    Me.fldComments = Left(Me.fldComments, 11) &
> Me.fldName & _
>    Mid(Me.fldComments, 12, Len(Me.fldComments))
> 
> If fldComments is not intialized then:
> 
>    Me.fldComments = "Thank you, " & fldName & _
>    ", for attending the seminar."
> 


__________________________________________________
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/

George,

<< Thanks for the reply, but my fldComments is not fixed.  I need this 
option for my email solution, means that fldComments is my Email Body. >>

I see.  If fldComments is not fixed, but it always starts with the 
phrase, "Thank you, fldName, for attending the seminar," then try this:

   Me.fldComments = "Thank you, " & Me.fldName & _
   ", for attending the seminar.  " & Me.fldComments

Note the two spaces after the period in "seminar" to separate the sentence 
from the upcoming sentence.

Greg

Greg,
Your very close. Actually no fix start phrase, just
imagine how you type your message in your email and
put my name anywhere you like. 

Another idea, if you aware about MsWord MailMerge that
you can insert any merged field anywhere, that's what
I want to incorporate to my Access Email Solution.

Make sense to you?
George

--- Gregory Serrano <SerranoG@m...> wrote:
> George,
> 
> << Thanks for the reply, but my fldComments is not
> fixed.  I need this 
> option for my email solution, means that fldComments
> is my Email Body. >>
> 
> I see.  If fldComments is not fixed, but it always
> starts with the 
> phrase, "Thank you, fldName, for attending the
> seminar," then try this:
> 
>    Me.fldComments = "Thank you, " & Me.fldName & _
>    ", for attending the seminar.  " & Me.fldComments
> 
> Note the two spaces after the period in "seminar" to
> separate the sentence 
> from the upcoming sentence.
> 
> Greg


__________________________________________________
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/