Have 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.
Stopping Unsolicited Mail, Phone Calls, and Email
Armen Stein
October 7, 2016
Have you ever been expecting an important package and opened your mailbox to find a stack of coupons and junk mail?
