505.369.1650 [email protected]

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 be...

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, form and report...