Hi!

I've programmed a database system for my small bussiness in access 2000. It ran perfectly but then I've upgraded it to Access 2003. The thing is: I have a subroutine wich eliminates "double spaces", "zero values", and other redundant data from a every text string in a selected record.

My procedure is as follows:

Function Limpiar()
    Dim A As Integer
    ' Eliminar medios con cantidades en cero
    SendKeys ("^l")
    For A = 1 To 20
        SendKeys ("%b")
        SendKeys ("??-/0")
        SendKeys ("%o")
        SendKeys ("{up}")
        SendKeys ("%z")
        SendKeys (" ")
        SendKeys ("%t")
    Next A
End Function

When I run it appears to work fine but it doesn't modify the data in the table.

Any suggestion? If you have an alternative way to modify strings of records will be also very usefull...

Thank you.