Author Archives: Jack

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 , , | Comments Off on Calculating travel time between two locations

Beginning a new Database

I’m about to begin the development of a database for the Navy (Military Naval Base Client in Maryland). The purpose of the database is to track inventory on the military base. I’ve already had interviews with the client and gotten … Continue reading

Posted in Access Code Examples, Inventory Database, Microsoft Access Solutions, Military Database, Navy Database, Uncategorized | Tagged , , , | Comments Off on Beginning a new Database

Manpower resource scheduling and communication with an Access Database for commercial contractors

I recently wrapped up database development for a commercial mason, Masonomics, here in Richmond, VA.  Masonomics is a large masonry outfit that works on a variety of government, educational, and commercial projects across Virginia.   They regularly run 10 or more … Continue reading

Posted in Access Code Examples, construction database, Legal Access Database, Manufacturing Access Database, Microsoft Access Solutions | Tagged , | Comments Off on Manpower resource scheduling and communication with an Access Database for commercial contractors

Populating a combo box with a new value

I really am not a fan of the code examples out there for adding an item to a drop down list.  I’d like to give you a simple example of how to approach. So here’s the scenario: You’ve got a … Continue reading

Posted in Access Code Examples, Legal Access Database, Manufacturing Access Database, Microsoft Access Solutions | Tagged , , , , , , , , , , , , | Comments Off on Populating a combo box with a new value

Data Comparison/Change made easy?

I do a weekly download from a .csv file (for my client). They want to visually compare the orig data (in a form) to the new data.  Then they may or may not want to accept any data changes. So … Continue reading

Posted in Uncategorized | Comments Off on Data Comparison/Change made easy?