Search results

Thank you, that's exactly what I meant. I know it's hard to tell without a specific example, but I would have to write and explain too much. To put it briefly, at my work I have an Access database with many queries with different criteria for different company departments. Each query serves as...

I know Access doesn't have cells like Excel. Is it possible to do something similar in Access VBA to the example I gave, but instead of Range("A1:A10"), refer to a query in Access? I wanted to create a macro in Access VBA which will open the query, change the text in the SQL view, save and close...

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: 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...