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 Windows Management Instrumenation (WMI) to obtain detailed information about your computer system / processor / BIOS / each hard drive or logical disk.
Remove core Windows 'modern' apps
Certain core Windows modern apps CANNOT be removed using Add/Remove programs.
However if you have a problem, these cannot be installed from the Windows Store as they are already installed! CATCH-22!!!
This article explains how to remove these core Windows modern apps using Powershell.
Rank Order in Queries
This shows one way of creating rank orders in Access queries using the Serialize function
List Access Error Codes
This is a procedure to create a complete list of Access error codes and descriptions
Add colour to queries, combos & listboxes
This article explains 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
This includes a procedureGetDatabaseStatistics which examines all tables, forms, reports, macros and modules in a project and produces statistics about the number of fields, controls, VBA functions, lines of code etc.
The results are saved to the VBE immediate window and to a message box
TIP: Fill down in tables, queries & forms
This explains a simple method of copying field values from one record to the next
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
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.
Access/Office 365/Windows Version Check
Add colour to queries, listboxes & combos
Centre Form On Screen
Check Procedure Exists
Close all VBE windows
Create Index on SQL View
Detailed System Info
Fill down in tables, queries, forms
Fix shrunken nav pane issue
Formatted Message Box
Get Computer Name
Get User Name
Get Value in Previous Record
Get full list of VBA references & locations
Linked No Tables
List of Access error codes
Manage Taskbar/Navigation Pane/Ribbon
Masked Input Box
Negative Total Pages On Report
Prevent Copy & Paste in Form
Rank order in queries
Remove core Windows modern apps using Power Shell
Remove deleted objects from MSysObjects table
Report Group Pages
Speed Comparison Tests
View all database objects
Complete List of Code Samples