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/basJStreetSQLTools.zip

Share this post

Share on facebook
Share on twitter
Share on linkedin
Share on pinterest
Share on print
Share on email

Related Articles

stack of dice - Backgammon Business & Life - J Street Technology - Custom Web Application - 98004

Backgammon, Business, and Life

As an Armenian, playing backgammon was pretty much expected of me from an early age. When I was 5, my mom said that she’d play with me, but I had to promise not to cry when I lost.

Read More »
picture of puzzle pieces - How Do You Solve Problems

How Do You Solve Problems?

Here at J Street, we say that we build and support database applications. But really, what we do is solve problems. Every day. That is our job. And it’s a skill that we’ve developed.

Read More »