Columns Archives - Extra Mile Data

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 an example of timing part of the...

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 the columns are just...

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

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. It includes dollar...

Count non-Null values across columns in a Microsoft Access record

by Carl Connett | Mar 10, 2009 | Data Type Functions, Microsoft Access, VBA

Need to get a count of the number of columns in the results of a MS Access query that are not Null? This VBA code will do it. You can apply the function in a query expression like this: CountNotNull: CountValues([Field1], [Field2], [Field3], [Field4], [Field5],...

What Customers are Saying about Extra Mile Data

Andrew H. Huffine
Ridge Funeral Home & Cremation Service, LLC

"Carl and Extra Mile Data was the easiest and quickest way to solve my MS Access problems. Our database is running properly, efficiently and faster after Carl made the necessary changes to fit our needs. He also taught me how to make any updates in the future making me more confident with our database. Extra Mile Data is highly recommended!"

Lynn Coleman-Kirk
Signature Companies

"Carl at Extra Mile Data has been extraordinarily helpful to our companies. He applied his vast knowledge and patience to match to solving all of our complex database needs that we were unable to handle ourselves. He and his company were a tremendous find and will be used again and again as needed."

Normand Menard, RPFT C-Tech
Upland Environmental Ltd

"I was looking for a database solution for my business and I'm glad I found Extra Mile Data. Carl was able to get me up and running with a database in no time at all and within budget. He has since helped me build this database into a very effective and efficient tool I use daily for my projects. I've very much enjoyed working with Carl and I will certainly continue to use him for any database programming in the future. 'Thanks Carl!'"

Jim Lipko, IT Administrator
The P.A. Hutchison Company

"My project “MS Access Salesperson Database” was at a standstill and then I found Extra Mile Data. With the professional help given to me by Carl my project was completed on time and on budget. Carl not only explained the programming as he went along, but he also showed me how I could add coding as well to achieve my desired results (Truly an Extra Mile). The database is an integral part of the day to day operations for our sales force and their supervisor."

William Green, Manger of IT/Marketing
Mascot Construction

“We hit a brick wall in the middle of our project, thankfully we found Extra Mile Data! Carl was great he took the time to understand our project, fix our problems, and help us with future Database endeavors."