Doc-Logs database

I first developed this application for the Daniel Industries technical publications group. Afterwards, I continued to improve Doc-Logs, and I used it in my other job assignments at PG&E Energy Trading and at the Compaq Revolution 2000 project.

Doc-Logs provides several useful reports, some printed and some for intranet (or web publication). At Compaq, I used Doc-Logs to produce a web page report listing document titles, revision levels, and descriptions. The web page served as the main file download page for documents in the Revolution 2000 Developers' Library.

Screen captures

	Slide Show (opens in another window)
	Startup screen, screens for comprehensive document information, document revision status, and query-by-form, plus a web page report that serves as a document library interface.

TECH NOTE: Reusable interface for query-by-form searches

In Doc-Logs, I set about making an easy-to-use form for searching the database. The result proved to be a winner. I have been able to reuse this form and its underlying code module, with a small number of revisions, in at least ten other MS-Access applications.

The form is designed to work simply, without complexity. It provides searching for only the most frequently sought criteria (that is, only a subset of the fields in the database). All search terms are ANDed and wild-card terms are applied to all text string search criteria. The WHERE clause is preserved in a string variable and reused by different code procedures for producing a 'results' report or opening the main data entry form with a filtered subset of records.

Below are screen captures of this Search form used in Doc-Logs and other applications I have built. (Did I happen to mention I really like the way it works?)

Screen captures

	Slide Show (opens in another window)
	Search forms examples for Doc-Logs database, CD Collection database, PC_Articles database, Shopper database, and Treasury Reconstruction database.