Use this VBA function to determine if a file is already open. For example, before attempting to import an Excel file into a Microsoft Access database, you can call this function, and if the file is open, notify the user that they need to close the Excel file first. ...
In a recent database project, the Courier font was no longer being recognized, and Microsoft Access was using the MS Sans Serif font and the System font to replace it. I used these VBA functions to replace MS Sans Serif and System with Courier (Detail) throughout the...
This VBA function uses the DateDiff() and DateSerial() functions to calculate an age in years. For example, if you would like to show the current age of an employee on a form or a report, you can call the function in the Control Source of a text box, and pass the...
Syncing one Microsoft Access form with another is made simple with this VBA function. It finds and moves to a record in a form by looking for a value in a specific field that is in the form’s recordset. For example, this would allow you to click on an employee ID in...
When you have a Microsoft Access database with a lot of macros, it can be a challenge to find all the places where an object is being used in the macros and replace it with a different object. These VBA functions will allow you to replace a value in a particular...
You may store file attachments in Microsoft Access by utilizing the Attachment field in table design. Unlike other field types, the Value property of the field is actually a recordset of the attached files. These VBA functions allow you to delete the attachments by...
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."
"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."
Making Microsoft Access Work. Call (505) 369-1650. Extra Mile Data, your source for Microsoft Access help
Manage Cookie Consent
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.