by Carl Connett | Jan 27, 2014 | Controls, Forms, Microsoft Access, VBA, Windows API
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...
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...