by Carl Connett | Jan 29, 2014 | Arrays, Collections, Controls, Forms, Loops, Microsoft Access, VBA
When you iterate through a collection of controls in a Microsoft Access form, the order of the list of controls that you end up with may not be sorted as you expect. Rather than being sorted by the tab index, the list will be sorted...
by Carl Connett | Nov 27, 2009 | Microsoft Access, VBA
If you’ve ever wished you could keep the Office Ribbon, but automatically minimize it to conserve space, this VBA function is for you. The same technique works for Microsoft Access, Microsoft Word, etc. The function includes two pieces of logic. The first...
by Carl Connett | Mar 10, 2009 | Collections, Databases, Forms, Loops, Microsoft Access, Module-related Functions, Modules, Objects, Queries, Reports, Tables, VBA
There are very sophisticated search programs to help you find occurrences of an object name or a piece of code within a MS Access database. I usually find that this VBA code is sufficient to do the job. It looks in tables, queries, code modules,...
