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://www.jstreettech.com/files/JStreetSQLTools.zip

Share this post

Related Articles

Armen’s Thoughts Article: What Do You Want?

When our teenage daughter was playing Select Softball, we would sometimes travel to other cities for tournaments. Teams from all over the country would gather at a large sports complex and play softball over a whole weekend.

Read More »
Stressed Women

What Does This Software Want From Me?

Few things are quite as frustrating as using some software and receiving an error message – except for receiving an error message that tells you NOTHING about what the problem actually is!

Read More »