by Carl Connett | Nov 27, 2009 | DAO, Microsoft Access, Tables, VBA
If you’ve ever imported a text file or a Microsoft Excel worksheet into Microsoft Access, you have seen how Access defaults the text field lengths to 255 characters. This VBA function will display the maximum length of the values currently in each field of a...
by Carl Connett | Aug 4, 2009 | Arrays, Collections, DAO, Databases, Forms, Macros, Microsoft Access, Modules, Queries, Reports, Tables, VBA
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:...
by Carl Connett | Apr 24, 2009 | Collections, Databases, Forms, Loops, Macros, Microsoft Access, Microsoft Excel, Modules, Objects, Queries, Reports, String Functions, Tables
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...
by Carl Connett | Mar 10, 2009 | Collections, Databases, Forms, Loops, Microsoft Access, Module-related Functions, Modules, Objects, Queries, Reports, Tables, VBA
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,...
