Showing 30 Result(s)

Database Calculations

Current Value vs. Previous Field Value Database Calculation Compare original value of field to new value of field in the after update event Ever wonder why it is so difficult to figure out what the original value of a form field was after the user updates the field? I thought that the Before Update event …

Medication Management

Medication Management / Prescription Tracking Personal Drug Dosage Tracking Below is a sample screen for a daily dosage tracking system. Our Access consultants will develop the forms and menus in any style you choose. Some data has been obscured to protect privacy. Note the photographs of the individual medications – this helps make identification of …

NotInList Event Code

NotInList Event Code Example Access Visual Basic NotInList Event Code Example Here are explained several examples of simple and complex combo box not in list event handling. There are times when you’ll need more advanced techniques to handle lists that are not a single-column dropdown list or combo box. In our NotInList example we have a bond trading …

Master Query in Visual Basic

Detail – Master Query in Visual Basic Set status fields of master record based on characteristic of detail records In this visual basic example let us assume we have two tables in a master/detail relationship. The main table contains Tasks which much be completed. The detail table contains one or more Action Items for each …

Database Support Services

Microsoft Access Support – Superior Support for Great Databases One of the primary advantages of using Blue Claw Database Design is our database technical support response time. Our goal is to have a 90% 1 hour response time to all existing customers.  That means that if we don’t answer the phone immediately we will do our best …

Work Order System

Maintenance Management Systems Below is a screen shot of a service work order management system developed several years ago – specifically the individual work order management screen.  The top features of the work order project were to a user friendly, comprehensive solution to the management of service work orders supporting the installation, service and  maintenance …

Database Examples

Example Access Download Our Free Microsoft Access Downloadable Tutorials demonstrate some of the more complex of Microsoft Access programming techniques. This is a new feature of our website.  We will be adding new working Microsoft Access tutorial downloads on a regular basis so check back often.  These free downloadable MS Access database examples contain all the visual …

Work Order Template Database

Work Order Template: Is the management of work orders critical to your business?  If your business involves the installation and service of equipment then this database may be perfect for you.  Do you have billable and non-billable service calls, warranty vs. non-warranty equipment?  If you have spring and fall maintenance or shutdown/startup contracts then this …

Grant Management Database Template

Complete Grant Management Software from Registration to Check Printing The Student Pell Grant Program provides federal grants to undergrad students who require financial aid to meet educational expenses. The non-repayable awards are available to eligible students attending approved universities, colleges, and vocational/technical schools and other approved post-secondary educational institutions. To apply for a Pell Grant, …

Templates

Microsoft Access Database Templates If you need help creating an Access database then checkout our template databases.  These database can give you a great head start with your database and may not require any additional modification or just a little. And, remember if you don’t see a database listed that meets your requirements then we …