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

Can You Spot A Great Leader - J Street Technology - Custom Web Application - 98004

Can You Spot A Great Leader?

A great leader can make all the difference between success and failure, productivity and frustration, satisfaction and disappointment. But how do you know when someone’s a great leader?

Read More »

The Hostage Situation

Recently we were contacted by a company that was in a tough spot. They had a thriving business, but things weren’t going well with their software developer/hosting company.

Read More »