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

Scroll in a Microsoft Access text box using the mouse wheel

Microsoft Access does not have built-in mouse wheel scrolling in form text boxes. You can provide mouse wheel scrolling by writing some VBA code in the Form_MouseWheel() event procedure.

Trying to scroll in a text box can be particularly frustrating if the bottom of the

read more

posted on: Jan 27, 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

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