-
Archives
-
Meta
Author Archives: Jack
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
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 Access Inventory Database, Access Military Database, Access Navy Database, beginning access database
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 construction database, human resource database
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 Access Database, access database code example sample notinlist combo box legal manufacturing health care distribution banking finance, Code Example, code Sample, combo box, Distribution, Health Care, Legal, Manufacturing, Maryland, North Carolina, notinlist, Virgina
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?