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

Determine if a value is in a VBA array

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

Remove replication from a MS Access database

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

Find duplicates in a VBA array

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

Using VBA to fill and manage a Microsoft Access list box

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

Notes

Some operating systems block files that come from other computers. If you cannot get a downloaded file to work properly, right-click over the file, select the Properties option, and then click the Unblock button at the bottom of the General tab.