Solved

MS Access Escape characters

Posted on 2011-03-15
9
579 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 

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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

739 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