VBA Archives - Extra Mile Data

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

Determine if a value is in a VBA array

by Carl Connett | Jan 23, 2014 | Arrays, Loops, VBA

This function will return a True if a particular value is found in an array. It works with one-dimension arrays only. For example, if astrCity is an array, you could check for the value Chicago like this: If InArray(astrCity, “Chicago”) Then ' Run logic here....

How to time VBA procedures and create a log of elapsed time

by Carl Connett | Nov 5, 2013 | Date, Time, and Age Functions, File Functions, VBA

This set of functions will let you track how long it took for one or more pieces of VBA code to run. The logic includes three sections: name and initialize the timer, end the timer, and write the results to a log file. Here is...

Get total hours and minutes from summing columns of Hours and Minutes

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

Use VBA to add days to a date but exclude Saturday and Sunday

by Carl Connett | Oct 8, 2013 | Date, Time, and Age Functions, Microsoft Access, Microsoft Excel, VBA

This function finds a date a certain number of days from a start date when weekends are not included. It can be used when your work week does not include Saturday and Sunday and you want to find a business day in the future. Microsoft...

« Older Entries

Notes

Some operating systems block files that come from other computers. If you cannot get a downloaded file to work properly, right-click over the file, select the Properties option, and then click the Unblock button at the bottom of the General tab.