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 … Tags: Debug.Print, ribbon,...
by Carl Connett | Jan 23, 2014 | Arrays, Loops, VBA
This function will return a True if a particular value is found in an array. It works with one-dimension arrays only. For example, if astrCity is an array, you could check for the value Chicago like this: If InArray(astrCity, “Chicago”) Then ' Run logic here....
by Carl Connett | Aug 4, 2009 | Arrays, Collections, DAO, Databases, Forms, Macros, Microsoft Access, Modules, Queries, Reports, Tables, VBA
This VBA function copies or imports all the objects and database startup properties from a Microsoft Access replicated database into an un-replicated database. It removes tablename_Conflict tables and removes replication-related fields like s_GUID, etc. Background:...
by Carl Connett | Jun 17, 2009 | Arrays, Loops, String Functions, VBA
This VBA function looks for duplicate values in an array. If it finds some, it produces a list of the duplicated values. It is a good example of how to loop through an array. The argument needs to be an array. Nulls in the array … Tags:...
by Carl Connett | Jun 3, 2009 | Arrays, Loops, Microsoft Access, String Functions, VBA
This set of VBA functions and MS Access example show how to use code to fill a list box, clear a list box, and retrieve selected items from a list box. The code is composed of 4 functions: ClearListBox() – Clears a list box. It … Tags: list...