Monthly Archives: March 2017

FTP files using Microsoft Access

I have an import/export client that runs their entire operation with Microsoft Access as a backbone application. This company has been in Fastcompany for a couple of years now. Today I had the opportunity to go back and slightly modify … Continue reading

Posted in Access 2007 problems/solutions, Access Code Examples, Microsoft Access Solutions | Tagged , , | Leave a comment

Finding data holes and filling them in Microsoft Access

Finding data holes and filling them in Microsoft Access So you are running 20 lines of production and you have 3 shifts a day. But some times you don’t run a shift due to a variety of reasons. You decide … Continue reading

Posted in Access Code Examples, Manufacturing Access Database, Microsoft Access Solutions | Tagged , , | Leave a comment

Calculating travel time between two locations

You need a way to automatically calculate the time to get from one location to another location. You might use this for giving your drivers directions to your clients. Or expand to be an efficient route because you are going … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment