Sample Techniques In Access

Here are some small sample downloads of Access databases that illustrate basic techniques. I will be adding to this list as time permits. Not all of these spring from my own diseased mind. Credit is given where due.

Download the file(s) you want, unzip them to a directory, and open the database in Access. Look at the DOCUMENTATION module for an explanation of each technique.  If there is no DOCUMENTATION module, look in the code behind a form. Some files are native Access databases - won't need to be unzipped.  

NOTE: These are all very basic techniques - if you're looking for advanced neat stuff you'll have to pay the tab. Click the little blue button to download the file. RIGHT Click on the blue arrow button or the link to download the file. If you are using Netscape 6x, RIGHT click and select "Save Link As..."

Here is a technique for creating dynamically dated, multiple row cross tab reports - A2K and A97 database examples, with illustrated WORD document for instructions.

How to make  a subform change HEIGHT according to the number of records..better late than never..

An example of how to use TABLE-DRIVEN list-box multi-select criteria for a query -

A quick short 1-form example of how to blink text on a form, as per an individual request on my Access forum  A97 & A2K versions in zip file.

Example of an automated, table driven report menu. 1 form, 1 table, about 10 lines of code. Look at form code for technique.  A97 version, will convert to A2K with no problems.

Here's a database of all Access & Jet errors. Submitted by John LaVenture -  -

Simple database example showing how first combo pick is used to restrict 2nd combo choices

Simple archive example for Mr/Ms Anonymous on the ElementK Access form

Example form showing sorting on labels and filtering on data - for Access forum

Problem resolution for JHERMIZ on the ElementK Access Forum - 2-key lookup table maintenance

Sample versioning system

An example of form text field animations for the ElementK Access forum

Use a combo box to "fill in" other fields on a form

Using combo boxes to filter records shown on a form

One form shows tables, click in list to see fields - see FORM1 for details

Displaying user-selectable SUBFORMS within a main form by using command buttons.

Dr. Jack "The Ripper" Austin's very nice example of how to FIND text in a string field.

Full-screen forms that "lock" the user into your system until they quit.

Dr. Jack "The Ripper" Austin's FORM SYNCHRONIZATION example.

An example of border-highlighting on text fields for folks in the Access Forum on ElementK..

An example of JOIN types for the ElementK Access forum

Posting combo box columns to fields in a record

Small print pages/copies control panel. Inelegant, but it works