Properties Archives - Extra Mile Data

Scroll in a Microsoft Access text box using the mouse wheel

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

Remove replication from a MS Access database

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

Get the name and description of all MS Access database objects

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

Scroll in a Microsoft Access text box using the mouse wheel

Remove replication from a MS Access database

Get the name and description of all MS Access database objects

Notes

Categories