Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 593
  • Last Modified:

MS Access Escape characters

Im trying to find out the correct escape codes to insert values in my memo fields

The memo field would look something like this
Hello Forms![frm_sales]![firstname],  I called and left you a voice mail a few weeks back
If I msgbox or have the code email this field out, I would like it to read
Hello Joe,  I called and left you a voice mail a few weeks back


I cant field the correct escape code to replace the field name with the actual value.. Any help would be greatly appreciated

Thanks
0
joein610
Asked:
joein610
  • 5
  • 3
1 Solution
 
Rey Obrero (Capricorn1)Commented:

Dim msg As String

msg = "Hello " & Forms![frm_sales]![firstname] & ", I called and left you a voice mail a few weeks back"

MsgBox msg
0
 
joein610Author Commented:
That the code works if it place that syntax in VBA editor.. but in this instance the memo field contains..
"Hello " & Forms![frm_sales]![firstname] & ", I called and left you a voice mail a few weeks back"


If I msgbox me!memo1  I get the same text as in the memo field
"Hello " & Forms![frm_sales]![firstname] & ", I called and left you a voice mail a few weeks back"


0
 
Rey Obrero (Capricorn1)Commented:
do you mean you entered these

"Hello " & Forms![frm_sales]![firstname] & ", I called and left you a voice mail a few weeks back"

in the table?
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
joein610Author Commented:
Correct... sorry for the confusion
0
 
Rey Obrero (Capricorn1)Commented:
if you really want this to come from table fields, add another field, say greeting (text)

enter
Hello in greeting field

enter
I called and left you a voice mail a few weeks back    in memo field

add the greeting field to your form, now you can do this


msgbox  me.greeting & " " & Forms![frm_sales]![firstname] & ", " & Me.memo
0
 
joein610Author Commented:
Gotcha... Thanks what I have now..  I must of been too was optimistic that there was something better :)

Thanks For your help!
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You're looking to include "tokens" or "placeholders" in your Memo field - in other words, you wish to have Text in the Memo field that could be used when generating a message, and you want that Text to dynamically grab the data from frm_sales? If so, then you can do this using specialized coding and placeholders. Enclose all of your placeholders in some unique syntax (for example: <CustName>).

When you need to use this Text value, add it to the form/report (or whatever object you need) and then build a routine that uses the Replace function to input your data:

Me.YourTextField = Replace("<CustName>", Forms("frm_Sales").CustomerName)

And so on for all your "tokens".
0
 
joein610Author Commented:
Let me try that...--  Sound pretty decent .. .. and I can prob make it compatible with my php programmers code.
0
 
joein610Author Commented:
I had a slight error with arguments because the orgianl field name  was missing, so i replace the code with

me!Me.YourTextField = Replace(Me.YourTextField, abc, "{first}", Forms![frm_sales]!CustomerName)


THANKS!!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now