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 … Tags: Columns, Format,...
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 | 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 … Tags: Format,...
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 | Jun 12, 2009 | Automation, Microsoft Access, Microsoft Word, String Functions, VBA
This VBA function opens/gets a MS Word document and finds the next occurrence of a specific string. The function provides a good example of using late binding automation and the AppActivate() function. One advantage of late binding (using generic objects, like objWd...