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 | Oct 22, 2013 | Date, Time, and Age Functions, Microsoft Access, Number Functions, VBA
This function can be used to return total hours or total minutes from a column of Hours and a column of Minute values. For example, in the table below, an Hours value was captured separately from a Minutes value in a time clock application. If … Tags:...
by Carl Connett | Nov 27, 2009 | Microsoft Access, VBA
If you’ve ever wished you could keep the Office Ribbon, but automatically minimize it to conserve space, this VBA function is for you. The same technique works for Microsoft Access, Microsoft Word, etc. The function includes two pieces of logic. The first...
by Carl Connett | Oct 6, 2009 | Macros, Microsoft Access, VBA
This example shows how to use a command line switch and a scheduled task to start a Microsoft Access application unattended and run some logic automatically. Perhaps you need a switchboard form to appear for users when they open a database during the day, but …...
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:...