Forum Discussion
Modifying query expression using VBA
I'm trying to find a way to change (overwrite) a query field expression based on a form text input using VBA. Is this possible?
Ex: Query field expression "ProjectID: 12345"
Enter "20201" in a Form
Update query field expression to "ProjectID: 20201"
JR2020610 Yes. it is referred to as "Dynamic SQL" and it is a very common technique for certain tasks.
Actually, I know of one excellent download site where you can get the VBA to do just that. Scroll that page to find "J Street SQL Tools".
JR2020610 Yes. it is referred to as "Dynamic SQL" and it is a very common technique for certain tasks.
Actually, I know of one excellent download site where you can get the VBA to do just that. Scroll that page to find "J Street SQL Tools".
George_Hepworth thank you so much. This looks like a great resource.
