***NEW CUSTOMER OFFER***
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

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 more

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

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

read more

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

Get the name and description of all MS Access database objects

This VBA procedure shows you how to create a simple list of the objects in a Microsoft Access database.  The list it creates includes the object type, object name, and object description, which can be parsed using the Excel file in the download.

Descriptions can

read more

posted on: Apr 24, 2009 | author: Carl Connett

Find where an object or code is used in a Microsoft Access database

There are very sophisticated search programs to help you find occurrences of an object name or a piece of code within a MS Access database.  I usually find that this VBA code is sufficient to do the job.  It looks in tables, queries, code modules,

read more

posted on: Mar 10, 2009 | author: Carl Connett

Live Chat Software