Solved Access 2007 Add notation to memo field in multiple records

December 22, 2012 at 12:15:50
Specs: XP Pro SP3 , P4 3.2 Ghz 2 GB RAM
I'd like to be able to add a note to a memo field in a contact form for multiple contacts using either a query, search and replace or a rubber chicken with magic incantations. I don't really care how I get there. What I want to be able to do is, after sending a few dozen e-mails, update each record with exactly the same phrase noting that I did so.

Search-and-replace works fine but doesn't seem to allow me to add in carriage returns/line feeds so the notation just looks like one long sentence.

An update query also doesn't seem to work. When I search for an exact phrase, nothing shows up because the field has other content in it. When I search for that same phrase with wildcards the records show up but the entire field is selected and eliminated, replaced with the target, meaning I lose all my other notes in the same field. There must be a simple solution to this but I'm not able to find it. People don't manually update each record do they? The update query likewise places the carriage return/line feeds literally instead of as an actual change of line.

Is VBA the answer?

Brian Grover, Author
BC Car-Free: Exploring Southwestern British Columbia without a Car
www.car-free.ca


See More: Access 2007 Add notation to memo field in multiple records

Report •


✔ Best Answer
December 30, 2012 at 12:10:22
You'll find the Solution Here: http://www.access-programmers.co.uk...

Brian Grover, Author
BC Car-Free: Exploring Southwestern British Columbia without a Car
www.car-free.ca



#1
December 25, 2012 at 08:29:49
No one? At least verify that it's not possible if that's the case.

Brian Grover, Author
BC Car-Free: Exploring Southwestern British Columbia without a Car
www.car-free.ca


Report •

#2
December 25, 2012 at 09:10:10
You might try asking your question over in the Programming or Database section,
might get at least some type of response.

Not a lot of Access users here, mostly Excel / Word / Outlook.

MIKE

http://www.skeptic.com/


Report •

#3
December 25, 2012 at 09:19:50
Thanks, mmcconaghy, I'll do that.

Brian Grover, Author
BC Car-Free: Exploring Southwestern British Columbia without a Car
www.car-free.ca


Report •

Related Solutions

#4
December 30, 2012 at 12:10:22
✔ Best Answer
You'll find the Solution Here: http://www.access-programmers.co.uk...

Brian Grover, Author
BC Car-Free: Exploring Southwestern British Columbia without a Car
www.car-free.ca


Report •

#5
December 30, 2012 at 15:01:04
Glad you found your answer and thanks for coming back with the update on the solution.

MIKE

http://www.skeptic.com/


Report •


Ask Question