505.369.1650 [email protected]

Code Snippets
+ Tips

Tips To Help You With Microsoft Access

Put your MS Access database on autopilot

This example shows how to use a command line switch and a scheduled task to start a Microsoft Access application unattended and run some logic automatically. Perhaps you need a switchboard form to appear for users when they open a database during the day, but you want the database to open automatically at night, skip the switchboard, and run some logic. One option is to create separate front-end databases. Another option is to give the database an autopilot that runs at night. Here’s how.

Find duplicates in a VBA array

This VBA function looks for duplicate values in an array.  If it finds some, it produces a list of the duplicated values.  It is a good example of how to loop through an array. The argument needs to be an array.  Nulls in the array are ignored by the logic, and the...

Use a VBA collection to store messages

This set of procedures can be used in Microsoft Access to collect messages during a process to display to the user after the process is complete.  It provides a good example of how to use collections in VBA. For instance, you could track the progress of some...

Get the name and description of all MS Access database objects

This VBA procedure shows you how to create a simple list of the objects in a Microsoft Access database.  The list it creates includes the object type, object name, and object description, which can be parsed using the Excel file in the download. Descriptions can be...

Find where an object or code is used in a Microsoft Access database

There are very sophisticated search programs to help you find occurrences of an object name or a piece of code within a MS Access database.  I usually find that this VBA code is sufficient to do the job.  It looks in tables, queries, code modules, form and report...


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.


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

Extra-Mile-Data-GearsMaking Microsoft Access Work. Call (505) 369-1650.
Extra Mile Data, your source for Microsoft Access help

Making Microsoft Access Work

No matter what your MS Access needs are, Carl can provide live help to make sure you get the solution you need.