Section Archives - Extra Mile Data

Template – Add title here

by Carl Connett | Jul 28, 2020 | Uncategorized

Tags: Section…

Get a list of form controls sorted by tab order

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

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

Use VBA to copy MS Access PivotTable values to the clipboard

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

Use VBA to return a column or row from a MS Excel range address

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

« Older Entries

Template – Add title here

Get a list of form controls sorted by tab order

Scroll in a Microsoft Access text box using the mouse wheel

Use VBA to copy MS Access PivotTable values to the clipboard

Use VBA to return a column or row from a MS Excel range address

Notes

Categories