Category Archives: Microsoft Access Solutions

Managing text communications (with an Access Database)

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

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

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

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 , , , , , | Leave a comment

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

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 , , , | Leave a comment

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 , | Leave a comment

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 , , , , , , , , , , , , | Leave a comment

User defined function to return first and last day of previous month

I have a recurring need from database to database to return the first day of last month as well as the last day of last month.  Usually in response to running a batch of update queries or possibly a data … Continue reading

Posted in Microsoft Access Solutions | Tagged , , , | Leave a comment