Get 15 minutes of free Live Help!

Get a list of form controls sorted by tab order

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

read more

posted on: Jan 29, 2014 | author: Carl Connett

Determine if a value is in a VBA array

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

posted on: Jan 23, 2014 | author: Carl Connett

Remove replication from a MS Access database

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.


The Microsoft support site describes some methods that can be

read more

posted on: Aug 4, 2009 | author: Carl Connett

Find duplicates in a VBA array

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

read more

posted on: Jun 17, 2009 | author: Carl Connett

Using VBA to fill and manage a Microsoft Access list box

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

read more

posted on: Jun 3, 2009 | author: Carl Connett

Live Chat Software