***NEW CUSTOMER OFFER***
Get 15 minutes of free Live Help!
Get 15 minutes of free Live Help!
You are currently viewing: DAO
Use VBA to get the maximum lengths of values in a MS Access table
If you’ve ever imported a text file or a Microsoft Excel worksheet into Microsoft Access, you have seen how Access defaults the text field lengths to 255 characters. This VBA function will display the maximum length of the values currently in each field of a
posted on: Nov 27, 2009 | author: Carl Connett
Remove replication from a MS Access database
This VBA function copies or imports all the objects and database startup properties from a Microsoft Access replicated database into an un-replicated database. It removes tablename_Conflict tables and removes replication-related fields like s_GUID, etc.
Background:
The Microsoft support site describes some methods that can be …
read moreposted on: Aug 4, 2009 | author: Carl Connett
Categories
- Automation (2)
- Collections (5)
- DAO (2)
- Errors (1)
- Featured (1)
- Home Page Rotator (5)
- Microsoft Access (17)
- Microsoft Excel (4)
- Microsoft SQL Server (1)
- Microsoft Word (1)
- SQL (1)
- Uncategorized (1)
- VBA (24)
- Arrays (5)
- Data Type Functions (3)
- Date, Time, and Age Functions (6)
- File Functions (1)
- Loops (7)
- Module-related Functions (1)
- Number Functions (2)
- String Functions (7)
- Windows API (1)
Rave Reviews
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!
Andrew H. Huffine
Ridge Funeral Home & Cremation Service, LLC.
2018-10-02T16:17:07-05:00
Andrew H. Huffine
Ridge Funeral Home & Cremation Service, LLC.
https://extramiledata.com/testimonials/803/
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.
Lynn Coleman-Kirk
Signature Companies
2018-10-02T16:18:55-05:00
Lynn Coleman-Kirk
Signature Companies
https://extramiledata.com/testimonials/805/
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'
Normand Menard, RPFT C-Tech
Upland Environmental Ltd
2018-10-02T16:19:26-05:00
Normand Menard, RPFT C-Tech
Upland Environmental Ltd
https://extramiledata.com/testimonials/806/
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.
Jim Lipko, IT Administrator
The P.A. Hutchison Company
2018-10-02T16:19:53-05:00
Jim Lipko, IT Administrator
The P.A. Hutchison Company
https://extramiledata.com/testimonials/807/
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.
William Green, Manger of IT/Marketing
Mascot Construction
2018-10-02T16:20:23-05:00
William Green, Manger of IT/Marketing
Mascot Construction
https://extramiledata.com/testimonials/808/
Working with databases can be daunting… but not when you work with Carl. Carl’s expert knowledge of MS Access and easy to follow pace and tutoring were extremely helpful. Although I was able to design and create most of my database, it was still missing some key functions and relationships. I left a message and Carl contacted me that same day. Carl took the time to work with me to understand our project and fix our problems. I will most definitely use Extra Mile Data for all my future database needs!!
Josie Molina, Executive Assistant to the President/HR Director
Ansh Labs LLC
2018-10-02T16:20:48-05:00
Josie Molina, Executive Assistant to the President/HR Director
Ansh Labs LLC
https://extramiledata.com/testimonials/809/
I’ve worked with Extra Mile Data several times over the past few years, and they have provided 100% satisfaction, 100% of the time. They understood my needs and delivered outstanding results, on time, every time.
Danny Farley, SW Regional Sales Manager
Pure Fishing- TEXAS
2018-10-02T16:21:12-05:00
Danny Farley, SW Regional Sales Manager
Pure Fishing- TEXAS
https://extramiledata.com/testimonials/810/
As is the case with most small businesses, finding the best person for key projects is oft times a disappointing venture. We took a chance on Carl and I’m very glad we did. His willingness to help, his wide knowledge base, his integrity and his cost structure has us coming back with new projects on a regular basis. I recommend him wholeheartedly.
Thomas E. Keegan, MSPH, Principal Managing Partner
Gemini Group
2018-10-02T16:21:45-05:00
Thomas E. Keegan, MSPH, Principal Managing Partner
Gemini Group
https://extramiledata.com/testimonials/811/
We had tried several vendors to help take our Access based system to the next level. Deciding to bring Extra Mile Data in and help us attain the next level was probably one of the three best decisions our business made last year. I appreciate working with Carl and utilizing his vast experience to improve my business. Triple thumbs up!
Clay Murray
Spur Mercantile, LLC
2018-10-02T16:22:11-05:00
Clay Murray
Spur Mercantile, LLC
https://extramiledata.com/testimonials/812/
I spoke with several different companies and I was not able to get the results I was looking for. Carl is in a league of his own. He is always on time for his appointments. He is meticulous, honest, easy to work with, and has been instrumental in taking my concept to reality. I recommend him to any and all who need his services.
Mark Goldstein
Production Link Software, LLC
2018-10-02T16:22:44-05:00
Mark Goldstein
Production Link Software, LLC
https://extramiledata.com/testimonials/813/
5 Stars!!!! The problem with most techies is that they understand systems and processes, but not business. Carl is the rare exception who understands that technology is a means to an end, and not the end itself. He asked questions each step of the way to understand exactly what we were trying to accomplish, so that he could choose the best methods for achieving our desired outcome – instead of merely selecting what’s the most technically efficient.
Glenn Shepard
Glenn Shepard Seminars
Nashville, TN
2019-03-08T10:09:11-06:00
Glenn Shepard
Glenn Shepard Seminars
Nashville, TN
https://extramiledata.com/testimonials/5-stars/
Services
- MS Access Programming
- MS Access Design
- MS Access Development
- MS Access Conversion/Migration
- MS Access Tables
Services
- MS Access Forms
- MS Access Reports
- MS Access Queries
- MS Access Macros
Services
- MS Access Modules – VBA
- MS Access Ribbons
- MS Access Relationships
- MS Access Support
Copyright © 2020 Extra Mile Data. All Rights Reserved | Website Designed and Maintained by The Belford Group.