Recent content by comeng

Sorted Thanks had looked through autocorrect and had missed ballance being there, sometimes the obvious is the easiest missed

Have an odd problem that eludes me at the moment I have table with a text field for surnames and if I type the surname Ballance into the table it automatically reverts to Balance can see no logical explanation for this at the moment funnily it does exactly the same in excel

Thanks very much that works, also found another way round as shown. As always with Access more ways than one of skinning the cat Public Sub AbbrevF(AbbrevForename As String, FullForename As String) Dim rstTable As DAO.Recordset Dim myForenameBefore As String Dim myForenameAfter As String With...

yes but get following error message Runtime error 3020 Update or CanceUpdate without AddNew or edit which I do not undestand because I use dbOpenDynaset

Hi Have the following code that works on Access 2000 Dim myForenameBefore As String Dim myForenameAfter As String With CurrentDb.OpenRecordset("Names", dbOpenDynaset) Do Until .EOF myForenameBefore = .Fields("Forename") myForenameAfter = Replace(.Fields("Forename"), "Elizh", "Elizabeth")...

ok found that will get back to you

thanks matt nearly got that but replace function keeps coming back with a compile error "Expected =" will keep looking to see what I am doing wrong. Incidentally using Access 2000 Phil

Hi Looking for help with partial text replacement I get various tables with Forenames in them some of which are shortened ie Elizh for Elizabeth, using an update query i can obviously convert all the Elizh's to Elizabeth but when the Elizh appear as the second or third name I am stumped ie...