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
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
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.
Background:
The Microsoft support site describes some methods that can be …
read moreFind 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 moreUsing 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