Articles

Solved Access 2007 Add notation to memo field in multiple records

December 25, 2012 at 09:30:58
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 •


#1
December 30, 2012 at 12:08:38
✔ Best Answer

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 •
Related Solutions


Ask Question