SOLVED

Modifying query expression using VBA

Occasional Contributor

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"

2 Replies
best response confirmed by JR2020610 (Occasional Contributor)
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". 

 

@George Hepworth thank you so much.  This looks like a great resource.