Solved

MS Access Escape characters

Posted on 2011-03-15
9
558 Views
Last Modified: 2013-11-28
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
Comment
Question by:joein610
  • 5
  • 3
9 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35137194

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
 

Author Comment

by:joein610
ID: 35137339
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
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35137376
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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Author Comment

by:joein610
ID: 35137404
Correct... sorry for the confusion
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35137494
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
 

Author Comment

by:joein610
ID: 35137806
Gotcha... Thanks what I have now..  I must of been too was optimistic that there was something better :)

Thanks For your help!
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 35138243
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
 

Author Comment

by:joein610
ID: 35138477
Let me try that...--  Sound pretty decent .. .. and I can prob make it compatible with my php programmers code.
0
 

Author Closing Comment

by:joein610
ID: 35139331
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question