Mendip Data Systems
Database applications for businesses and schools
Code Samples Page 1 (of 3)
To provide feedback on a code sample, please enter your name, e-mail address and company (optional) below, add your comment and press the submit button. Thanks
All code samples are free to download and free to use in your own applications providing any copyright notices are included without any changes made.
All code will work in both 32-bit and 64-bit Access unless stated otherwise.
We do not give the same support to these code samples as for our commercial programs. However, please contact us if you have questions or suggestions for improvements.
Detailed System Info
This uses Wndows Management Instrumenation (WMI) to obtain detailed information about your computer system / processor / BIOS / each hard drive or logical disk.
Updated 26/08/2018
Remove core Windows 'modern' apps
Certain core Windows modern apps CANNOT be removed using Add/Remove programs.
This article explains how to remove these core Windows modern apps using Powershell
Updated 16/06/2018
Rank Order in Queries
This shows one way of creating rank orders in Access queries using the Serialize function
Updated 09/06/2018
List Access Error Codes
Updated 03/06/2018
Add colour to queries, combos & listboxes
This article explians how colour formatting can be used for formatting text, number and date fields in queries and tables.
A similar approach can be used for text boxes, combo boxes and list boxes in forms
Updated 14/02/2018
Database Statistics
The results are saved to the VBE immediate window and to a message box
Updated 10/11/2017
TIP: Fill down in tables, queries & forms
Updated 15/01/2018
Remove deleted objects from MSysObjects
The read only system table MSysObjects keeps a record of all items in a database so these can be used by forms/reports/module code etc. Normally the MSysObjects table works perfectly but things can go wrong leaving incorrect data in the table e.g. if the database crashes for any reason.
This article discusses 3 types of problem that can occur & a solution for each
Updated 15/05/2017
View All Database Objects
This item allows you to view all objects in a database.
The list of database objects is obtained from the hidden system table MSysObjects.
It is updated automatically as objects are added to or removed from the database.
Updated 26/10/2020
If you found this site useful, please consider giving a donation to help offset the costs in keeping it running. Thanks.
Access/Office 365/Windows Version Check
Add colour to queries, listboxes & combos
Application.UserControl property
Fill down in tables, queries, forms
Get full list of VBA references & locations
Manage Taskbar/Navigation Pane/Ribbon
Negative Total Pages On Report
Remove core Windows modern apps using Power Shell
Remove deleted objects from MSysObjects table
Complete List of Code Samples