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;
- 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
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.
- Click the download link.
Your browser will display a file download dialog box.
MSH Library - Tools And Utilities v2017-04.zip to any location on your hard drive.
- When the download is complete, follow these steps:
- browse to where you saved
MSH Library - Tools And Utilities v2017-04.zip,
and right-click it.
- Choose "Extract All" from the right-click menu.
- 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.
- Double-click the extracted
MSH Library - Tools And Utilities v2017-04.accdb file.
- Windows will launch MS Access and open the database application.
- 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
- 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.