FMS Total Access Developer Suite Oh No... Not CODE! Karl Moore
When I initially started tinkering (technical term, that) with Microsoft Access, one of my biggest worries was VBA code. I searched the help file for solutions. Scoured newsgroups. Joined mailing lists. Browsed the shipped samples. I even threatened the Microsoft Press Office with a bad review or two if they didn't provide free technical support. And they did.
But still, finding the code to do just what you want is pretty darn difficult. That's where the first of the five products comes into play -- Total Access SourceBook. Hosting over 550 fully tested Access procedures, this application can really add power to your program -- even for those who possess little VBA knowledge.
Despite its pretty naff File Manager look, the system is really quite powerful with procedures covering:
* Access Forms, Macros and Modules, Queries, Reports * Attached Tables * Client/Server and ODBC * Converting Data Types and Units * Data Operations * Date and Time * Error Handling * File and Disk Operations * Information - General, Single/Multiple Objects * Internet, Intranets and the Web * Interoperability - DDE, Excel, Word * Math - General, Area and Volume, Statistics and Probability, Trigonometry * Searching and Sorting * Security and Workgroups * String Operations * Windows Clipboard Operations * Windows Common Dialogs * Windows Registry
I've seen a fair number of code libraries over the years I've worked with Access, but this surely has to rank as one of the best. In fact, *the* best. Superbly commented with full descriptions and a working cut-'n'-paste example.
In addition, the code system supports a multi-user development environment, allowing you to easily add to its cave of glistening code.