Category Archives: Access Code Examples

Access Driven Web Sites

You can control your web content with an Access Database. That’s how we run our website(s)! So, here’s the datacontrolllc.com website showing 3 lists of clients: Subcontracting / Build-Fixing / Integrating We’re going to concentrate on the first list of … Continue reading

Posted in Access and SQL Server, Access Code Examples, Access Database on Web | Comments Off on Access Driven Web Sites

Combination Form Filters

I’m often asked by clients to perform combination filters. That is, not just a single filter on a form.  But combining multiple filters that interact with one another. For instance, in the Marketing Database I’ve built for datacontrolllc.com, I have an … Continue reading

Posted in Access Code Examples, Access Database Advanced Forms, Access Database Filters | Comments Off on Combination Form Filters

Access and Word Integration

Recently we’ve been asked by a number of clients including Roofing Consulting Services (Consultants, Richmond, VA), KnoxMarine (Surveyors, Charleston, SC) and Hirschler Fleischer (Attorney, Richmond, VA) to integrate Access with Word. What these companies have in common is that they … Continue reading

Posted in Access Automating Word VBA, Access Code Examples, Access Database Advanced Forms | Comments Off on Access and Word Integration

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 , | Comments Off on Managing text communications (with an Access Database)

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 , , | 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 , , | Comments Off on Finding data holes and filling them in Microsoft Access

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