Cancel Undo (Download
A few examples of methods of controlling exiting and
validation from a bound form.
Combo Filtering (Download
A single form example of three related methods to limit the rows in combo based on initial characters.
Command Label (Download
A quickly implementable class method for using labels as command
buttons on forms.
Handles clicking appearance - and you can assign functions to
A few variations on the theme of allowing combo's in continuous
forms to maintain different rowsources on each row.
Outlook Email Class (Download EmailSend.zip)
Example of creating an Outlook email and sinking an Automation event to determine if it is sent or cancelled.
Multiple Form Instances (Download
The core simple concept of creating multiple instances of a single form.
Showing three different methods of persisting those multiple instances.
Add Form Record (Download
Adding a record using a dialog form.
Shows bound and unbound dialog methods of creating and then displaying a new record.
List Selections (Download
A quite comprehensive listing of different methods of selecting
Including subform selections with checkboxes, listboxes and
general selection methodologies.
Basic Dynamic Menu Bars (Download
A very simple little example of how to make your menu or toolbar
selections adaptable based upon the current form.
Record Navigation Buttons (Download
Example of nav buttons implemented as a subform you can place on any form to acquire the functionality without adding any code.
Report Space Filling (Download
An example which extends some methods of report filling provided
by the Microsoft Report examples.
It includes different ways of making reports fill a page
and keep footers stationary.
Report Page Totals (Download
An example report which shows two methods of displaying page total calculations.
Report Unbound (Download
Don't get excited, much of the usual power of reports (grouping, subreports etc) isn't going to happen.
For a simple display list printouts then you can use an unbound report to display data from a recordset.
Search Methods Example (Download
Examples of making basic search forms from standard query driven to those using
generated SQL statements.
Some of which are easier to add new search fields as they use
an iterative method of criteria building. (For parsing out multiple criteria with wildcards see SearchParse.zip.)
Storing BLOB data (Download
A core example of loading and showing files stored as BLOB (Binary Large OBject) data.
This is entirely different to OLE format images and doesn't result in db size bloat.
Storing Picture data (Download
An example of loading and storing image data using Access internal PictureData format.
Another way to avoid bloat and allow easy image re-use.
Storing Signatures (Download SigStore.zip)
Following on from above - adding Stephen Lebans' brilliant Image Class to allow signing/drawing and saving those.
Subform Value Rank (Download
Demonstration of using a subform's already loaded data to extract values from its rows rather than hitting the database again for information which can be worked out. (See also SubformReuse.zip for a more direct example of subform data use.)
Transactions In Forms (Download
A test bed showing how ADO and DAO recordsets can wrap bound form functionality.
While not comprehensive or clean - it shows the basics of how to achieve it.
For full such control consider a combination of other techniques, e.g. Unbound or Disconnected data.
Unbound Form Example (Download
A small example of an unbound form for those unaccustomed to
Specific Examples and Implementations
The following files are quite specific implementations of a particular technique.
Though not very widely applicable, they use concepts which may be of interest.
Before Current (Download
An example file showing how to emulate a BeforeCurrent event (when leaving a record) using a bound ADO recordset.
Class Properties (Download
An example file showing how to include a standard Properties collection in your own custom classes.
Colour Sliders (Download
An example use of the MS ActiveX Slider control to select RGB colour.
Datasheet Labels (Download
Maintaining a parent form set of labels above the movable columns of a datasheet subform.
Datasheet Columns (Download
Re-establishing a datasheet form's column widths as previously set.
Forms In Sync (Download
A slightly convoluted method of keeping two forms displayed records in synchronisation using Class module event sinking.
And a simplified variation (FormsInSyncSub.zip) to sync a detail form and subform for selecting record to display.
Identity Form (Download
Simply a utility form to demonstrate / prove the effectiveness of different methods of retrieving a new Autonumber value in code.
Advisor Article Example Files
The following files are the accompanying example MDBs to articles printed in DataBased Advisor publication.
The articles themselves can be accessed by the paying subscribers in the relevant issues of Advisor.
The example files containing the code and examples are provided here for general use.
Bind Any Data to an Access Form by Generating Recordsets (Download
Creating ADO recordsets from scratch allows a developer a great deal of freedom.
Fill the recordset with whatever you want - live data and extra fields you've added too - perhaps to use as a selection aid.
This example allows binding that recordset to a form (Access 2002+) - for editing and appending to the disconnected data.
(Example Implementations "RecordsetBind Example.zip")
Hierarchical Data in Access with Shaped Recordsets (Download
Hierarchical (Shaped) Recordsets allow convenient, powerful selection of data which is then available to easily walk, read and edit.
This example first offers a method of building your shaped recordsets without having to wade into the construction of the SQL statement.
Then, as example use, implementing the data structure in a TreeView control.
Finally we return to form binding (Access 2002+) showing how to, easily, bind live data to a form with additional fields.
(Example use in form updates "RecordsetShapeUpdates.zip")