Business Home   Software Index
Go to Business Home

Demonstration Applications & VBA Code Libraries

from Matthew S. Harris &

Go to software index page

MSH Library - Tools & Utilities
Opening screen of MSH Library - Tools And Utilities Code Library

Download MSH Library - Tools And Utilities (3,088 Kb)

View the Documentation:
MSH Library - Tools And Utilities v2017-04
(PDF, 1,593 Kb)

MSH Library - Tools And Utilities is a VBA code library providing tools for a large number of programming tasks. This library provides VBA code for:

  • Confirmations – confirm deletions and global data changes.
  • Data Validation – Validate user-entries with user-friendly error messages.
  • Dates – Populate combo-box/list-box controls with quarters of the year, compute the next quarter of the year, & other date-related tasks.
  • External Databases – Get the names of forms & reports in another database; open forms & reports in another database; create a new database linked to tables in the current database.
  • Files – Test the existence of disk files & folders; create a unique filename; extract file name, file type & file path from a fully qualified path. New in v2017-04: Get available disk space, total disk space, file size, file creation and last modified timestamps. Scale file-size and disk-size values in KB, MB, or GB.
  • Strings – Make lists; assemble SQL WHERE clauses, filter strings; format names.
  • Tables – Test whether tables exist, create unique temporary table names.
  • List Box Controls – For multi-select list boxes: Clear all selections, select all list items, invert selection, move item in list up or down (for value lists). (New in v2017-04.)
  • Forms & Reports – tools to make using the OpenArgs argument of Forms and Reports easier to use: assemble an OpenArgs argument string, and parse specific argument values from the string. (New in v2017-04.)
  • UI Control – Control the appearance of the MS Access Navigation Pane.
  • Measurement Conversions – Over 75 functions to convert measurements – area, distance, volume, liquid, weight, temperature, speed – in the same measurement system (e.g. pounds to ounces) or between US and Metric (e.g. centimeters to inches).
  • Sorting – Sort the contents of single or multi-dimensional arrays and single- or multi-column list-box and combo-box controls.
  • Operating System – Get information from the operating system, create Windows short-cut (.LNK and .URL) files.
  • And More!

Other features of the MSH Library - Tools And Utilities v2017-04 library:

  • Contains full documentation in PDF format
  • Developed in MS Access VBA (Visual Basic for Applications)
  • For MS Access 2007 (Service Pack 3) through MS Access 2016
  • Modules, forms, and other database objects are unlocked and available for inspection and modification.

This is not public domain software. It is licensed to you at no cost.
MSH Library - Tools And Utilities v2017-04 and its documentation are released to you under one or more of the GNU Public Licenses. Each pertinent GNU license is included in full as attachments in the MSH Library - Tools And Utilities v2017-04.accdb. You may read the pertinent licenses in the MSH Library - Tools And Utilities documentation before downloading the source code. You agree to be bound by these license agreements at such time as you utilize the VBA source code, and/or distribute this or new versions of the code and/or its documentation.

Having trouble getting this application to work?
Use the Contact Me button to ask for help.

Download Directions

  1. Click the download link. Your browser will display a file download dialog box.
  2. Save MSH Library - Tools And Utilities to any location on your hard drive.
  3. When the download is complete, follow these steps:
    1. browse to where you saved MSH Library - Tools And Utilities, and right-click it.
    2. Choose "Extract All" from the right-click menu.
    3. Follow the prompts in the Extraction Wizard to extract the MSH Library - Tools And Utilities v2017-04.accdb file to a location of your choice.
  4. Double-click the extracted MSH Library - Tools And Utilities v2017-04.accdb file.
  5. Windows will launch MS Access and open the database application.
  6. Unless you have extracted the .accdb file to a "trusted" location (as defined in your MS Access local configuration), you will see a security warning message under the MS Access ribbon.
  7. Click the Enable Content button (or the Options button, depending on your version of Office) to allow execution of the VBA code in the MS Access database.
Copyright © 2017 by Matthew S. Harris