-
Archives
-
Meta
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 contact access database, texting access database
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 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
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