I have a 2003 Access DB. There is a table (tMain) that has a memo field (Notes).
I would like to run through the entire DB and remove part of the memo fields contents "PT notified of DS office"
I am not familiar with DAO but modified some code that I found but its not working.
Dim rsD As DAO.Recordset
Set rsD = CurrentDb.OpenRecordset("tMain")
Do While Not rsD.EOF
rsD!Notes = Replace(rsD!Notes, "PT Notifed of DS office", "")
Set rsD = Nothing
Any suggestions? Is this even possible?