Mendip Data Systems
Database applications for businesses and schools
Code Samples Page 2 (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.
Close All VBE Windows
This is a simple function to close all VBE windows. This is very useful when so many windows are left open you can't find anything. It also significantly speeds up loading the VBE editor if it doesn't need to load lots of unwanted 'legacy' windows
Updated 14/07/2017
Get list of VBA References & locations
This article describes two different routines giving a list of VBA references & their locations.
This can be useful if you need to create a fresh copy of your database or deal with reference issues on a client machine. In such cases, it can be difficult to identify where certain references are located and the small size of the reference window doesn't help.
Updated 05/11/2017
Create Index on linked SQL View
This article explains how to add an index to a linked SQL Server view so that the data can
Updated 25/11/2017
Manage Nav Pane / Ribbon / Taskbar / Application Window
This article explains how to manage parts of the application interface using VBA:
a) Navigation Pane - hide / mimimise / maximise
b) Ribbon - hide / minimise / maximise
c) Taskbar - hide / show
d) Application window - hide / show
Updated 28/10/2017
Fix shrunken navigation pane
Sometimes the width of the navigation pane can become so small that it cannot be expanded by standard methods.
This article describes 3 methods of solving the issue if it happens to you
Updated 11/05/2018
The 'Upend' Query
A very common database task is to both append new records to a table and update existing records. The standard approach is to use an APPEND query and an UPDATE query.
However, this article explains how to combine both of these into a single 'UPEND' query.
Updated 18/09/2018
Prevent Copy & Paste in Forms
Updated 29/10/2017
Group Page Numbering in Report
Updated 21/12/2017
This article explains how you can reset the report page numbering at the start of each new group
Easter Calculator
Updated 07/07/2017
This is a 3 line function which calculates Easter Sunday for any year up to 2368.
It is adapted from code originally done for Excel by Chip Pearson
If you found this site useful, please consider giving a donation to help offset the costs in keeping it running. Thanks.
Formatted Message Box
Updated 03/07/2017