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
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
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.
Thanks, mmcconaghy, I'll do that. Brian Grover, Author
BC Car-Free: Exploring Southwestern British Columbia without a Car
www.car-free.ca
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
Glad you found your answer and thanks for coming back with the update on the solution.
