J Street SQL Tools

imagesqlHave you ever wanted a simple way to modify part of a SQL Statement in your VBA code? With these J Street functions, you can easily replace the Where and Order By clauses of any SQL Statement. This enables you to reuse query definitions, manipulate rowsource properties, and use passthrough queries with more flexibility. Leave the main part of the query unchanged – just change the selection and sorting! We use these routines in every Access application we build. Just paste the VBA text into a new Module named basJStreetSQLTools. Text file, 3K.

https://jstreettech.com/files/JStreetSQLTools.zip

Share this post

Related Articles

Give It A Break

Give It A Break

Way back in the early days of my career, I was a software designer at DIS Corporation in Bellingham, WA. I helped design and build dealership software for farm equipment and automobile dealers.

Read More »
Hackers - J Street Technology - Database Programmers - 98004

Scammers And Hackers: On The Prowl

During this trying time, not only do we have to worry about the pandemic, the economy, and our friends and family, scammers and hackers are doubling (tripling?) their efforts to get a hold of your valuable information.

Read More »