-
Archives
-
Meta
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 Microsoft Access FTP, Microsoft Access import and export business, Microsoft Access vba code examples
Comments Off on FTP files using Microsoft Access
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 access sub procedures, vba currentdb.execute, vba recordset
Comments Off on Finding data holes and filling them in Microsoft Access
Using a stored graphic consistently throughout your database
So you want to have a company graphic on all of your reports and forms? But you also don’t want to store the graphic 20 times in each object? And you don’t want to hyperlink to the graphic because your … Continue reading
Posted in Access Code Examples, Uncategorized
Tagged access database graphic, access database image, access database logo
Comments Off on Using a stored graphic consistently throughout your database
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 access consultant, access developer, access map
Comments Off on Calculating travel time between two locations