505.369.1650 [email protected]

Code Snippets
+ Tips

Tips To Help You With Microsoft Access

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

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 are ignored by the logic, and the...

Use a VBA collection to store messages

This set of procedures can be used in Microsoft Access to collect messages during a process to display to the user after the process is complete.  It provides a good example of how to use collections in VBA. For instance, you could track the progress of some...

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.

Categories

Making Microsoft Access Work

No matter what your MS Access needs are, Carl can provide live help to make sure you get the solution you need.