Dec 15 2020 01:05 PM
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"
Dec 15 2020 01:10 PM
Solution@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".
Dec 15 2020 01:31 PM
@George Hepworth thank you so much. This looks like a great resource.
Dec 15 2020 01:10 PM
Solution@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".