Hello,
I wanted to create a VBA macro in Access that would find and change text in a query in an SQL view.
I wanted to do it like in Excel:
But I don't know how to implement it in Access VBA. How to refer to a query?
I wanted to create a VBA macro in Access that would find and change text in a query in an SQL view.
I wanted to do it like in Excel:
Code:
Sub Find_and_Replace()
Range("A1:A10").Replace What:="text1", Replacement:="text2"
End Sub
But I don't know how to implement it in Access VBA. How to refer to a query?