Category Archives: Microsoft Access Solutions

Managing text communications (with an Access Database)

Posted on August 18, 2017 by Jack

You can manage your texting using an Access Database. Contact us at www.datacontrolllc.com or jjaeger@datacontrolllc.com to learn more. You can purchase this Access database for $100.00

Virginia, Henrico County Public Schools Facilities/Projects/Asset Management Database

Posted on April 11, 2017 by Jack

We’re particularly proud to work with one of the best counties in the United Stated (and the home of Data Control, LLC!) We have built and implemented an Asset / Facility / Project tracking database for Henrico County School Systems. If … Continue reading →

Posted in Announcements/News, Government Database, Microsoft Access Solutions, Uncategorized | Tagged Asset Access Database, City Access Database, County Government Access Database, Facility Access Database, Government Access Database, School System Access Database | Comments Off

FTP files using Microsoft Access

Posted on March 21, 2017 by Jack

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

Finding data holes and filling them in Microsoft Access

Posted on March 15, 2017 by Jack

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

Beginning a new Database

Posted on December 20, 2016 by Jack

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

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

Posted on June 19, 2014 by Jack

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

Populating a combo box with a new value

Posted on June 12, 2014 by Jack

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