by Carl Connett | Jul 28, 2020 | Uncategorized
Tags: Section…
by Carl Connett | Jan 29, 2014 | Arrays, Collections, Controls, Forms, Loops, Microsoft Access, VBA
When you iterate through a collection of controls in a Microsoft Access form, the order of the list of controls that you end up with may not be sorted as you expect. Rather than being sorted by the tab index, the list will be sorted...
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 | Jul 7, 2009 | Automation, Microsoft Access, Microsoft Excel, PivotTables, VBA
This function uses a combination of Microsoft Access, VBA, and Microsoft Excel to transfer the values from an Access form in PivotTable view to the clipboard. It is a good example of automation using late binding. The Challenge My goal was to automate the process...
by Carl Connett | Jul 7, 2009 | Microsoft Excel, String Functions, VBA
This VBA function returns the first row, last row, first column, or last column of a Microsoft Excel range address. It is also a good example of using a custom enumerated type. A typical range address is a string that defines a rectangle of cells. ...
