Document Text stored in tables

1959 Downloads

This example shows how to use tables to store the all the parts of a document.  An  exmaple web be for  creating contracts.

This example also shows how to use cascading sub forms. This is where two sub forms on hte parent for are linked. The first sub form shows records related to the Parent form's current record.. The second sub fom (on the parent form) shows related records to the current record in the other sub form.

Category: Example Forms
File Size: 120.11 KB
File Type: application/zip
Hits: 19946 Hits
Download: 1959 times
Created Date: 03-12-2016
Last Updated Date: 03-12-2016

Related documents

Orders.mdb and Solutions.mdb
Orders.mdb and Solutions.mdb

The Orders and Developer Solutions sample databases that are included with earlier versions of Microsoft Access were not included with Access 2000.

The Orders and Developer Solutions sample databases for Access 2000 are now available

Orders   The Orders sample application is a sample order entry and invoicing system. Its features include the ShowEvents form, which helps you see the order in which events occur when you are working with forms and controls, and custom data filtering capabilities that you can use in addition to the filtering functionality provided by Access. The initial chapters of Microsoft Access 2000: Building Applications with Forms and Reports explain how to build the features shown in the sample application.

Developer Solutions   The Developer Solutions sample application contains examples of the forms, reports, and interface elements you most commonly use to create applications. From changing a form’s toolbars in response to events to creating a crosstab report with dynamic column headings, the objects in Developer Solutions illustrate the main areas of application design. This sample application also includes procedures that you might find useful as you develop your own applications—for example, you will find procedures that link tables at startup, close all objects when the user exits the application, and capitalize the first letter of every word in a field.

For more details see: Microsoft Access 2000: Building Applications with Forms and Reports

 

25 Cool Control Tricks
25 Cool Control Tricks

Author: database Creations

 

 

Access Treeview Example - Organization
Access Treeview Example - Organization
Displaying Hierarcharical Data. This example uses Employees and the people under them with multiple levels.
Centering a form in the Access window
Centering a form in the Access window

Author:  Peter Schroeder

This  example (A2K format) contains a module that can be used to reliably center (both horizontally and vertically) a form in the Access Window. There is a very simple demo of how it works, as well. The module itself uses Windows API calls to determine the Access application client area and the dimensions of the form in question, and calculates what the TOP and LEFT settings of the form should be to be centered in the Access window.

 

To use, simply insert the entire modCenterForm into your own database. It is called as follows:


Code:


 

Call gfncCenterForm([form])

Audit Trail
Audit Trail

By Candace Trip (utter:angel) - Access 2000 format

 

This db demonstrates how to set up an audit trail of changes to the data including ID, Field Name, the field value before it was changed, the field valueafter it was changed, the user who did the change, and the date/time the changewas made.

Schedule Grid - DesGrid
Schedule Grid - DesGrid

The company that originally deployed this product no longer supports it. The product has since given it to public domain  soley as an "as is" device. Their information has been stripped out of the attachments and manual. This tool is what it is and is considered "skilled" to "advanced" for level of developer skills to manipulate successfully.

Basically, you're on your own with this one. But it is an excellent portrayal of Access' capabitlies.

 

The download includes both  Access 97 and Access 2000 formats of these two files:

1) Orchid (the demo)

2) DesGrid (the un-altered components) 

Each contains a Month-Grid and an Hour-Grid. Also included is a PDF of the Manual.