ribbon Archives - Extra Mile Data

Get a list of form controls sorted by tab order

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...

How to use VBA to minimize the Office 2007 Ribbon

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...

Find where an object or code is used in a Microsoft Access database

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,...

Get a list of form controls sorted by tab order

How to use VBA to minimize the Office 2007 Ribbon

Notes

Categories