Bringing higher-level concepts to VBA Access
There are much more advanced languages than VBA (e.g. Python), but here it is, you have to work with Ms-Access. Is everything lost? No! The ecosystem is actually quite rich. It's only that it's not immediately accessible and not many people really bothered to work things out in a way that they could be used by others.
There are actually things that you can do, with this set of modules:
- Databases: Use rows from tables/queries as dictionaries (as everyone in their right mind would do today); easily establish connections and compose queries for Access, SQLServer,Oracle, and MySQL!
- RegExp2: Using regexps in your application easily.
- Parameter: How about a little parameter table for your app, with all whistles and bells?
Nothing fancy here:
- Clone the repository or download the modules (
Database.bas,Parameter.basandRegExp2.bas) - In Ms-Access, open the Visual Basic Editor (Alt-F11)
- From File menu, choose Import and select the file you want import
- Set up the libraries you need (they are indicated in the header of your module): from the Tools menu, choose References to display the References dialog box (see more information on Microsoft Dev Center.
For a description of the API, and usage examples, see the wiki pages.