Sandra Daigle's Microsoft Access Database Samples

DbUtilities 2000 Addin
(2/23/2005)

 

DbUtilities 97 Addin
(2/23/2005)

 Author: Jeff Conrad (aka "Access Junkie")

This is a fantastic re-write of DbUtilities which,  as an Add-in, makes it easier to transfer the object permissions from a secured database to a new database container.

The Zip file also includes a complete user guide which covers installation, usage and walk-through guides.

Select the appropriate Zip file for whichever version of Access you are using.

Thank you to Jeff for creating this easy-to-use add-in!

CommandBars
(Version 1.0 - 11/9/2003)

Table driven CommandBar and Toolbar generator.

 

This application makes it easier to create and maintain custom command bars and toolbars.

 

Also contains sample usage of a TreeView control.

clsCtlGroups
(version 3.1 - 4/26/2003)

Collection class for creating and managing groups of controls on a form.

 

Slightly restructured, hopefully a bit easier to use and with new examples.

ReportDialog
(version 2.0 - 4/7/2003)

Sample database showing how to use tables and listboxes to create groups of reports and a generic report dialog.

 

Also shows a simple way to use a form for getting report parameters.

DbUtilities 1.0

Utilities to copy permissions from an existing database and then reapply the permissions to a new database with the same structure. Useful when a new database must be created by importing objects into a new database.

DbUtilities 1.1

Same as above, minor changes for Access 97 compatibility

Progress Meter 2.0

Sample database to show how to create and use a  reusable progress meter form. I personally like and use the Progress meter in Total Access Components by FMS but you can use this as a cheap (free) knock-off.

New version includes examples using standard Access Progress meter and Microsoft ActiveX Progress Meter.

Also demonstrates the code needed to allow the user to press the Escape key to break out of a lengthy process.

Synch Combo Continuous Sample database to show different method for synchronizing combos on continuous forms.
Select Records (version 3.0 - 8/20/2003) Sample showing one way to use a pair of multiselect listboxes to add/remove records. This example uses a very simplified tblPersons, tblClasses, tblPersonClasses example. The form allows you to select a person, then add or remove classes for that person. The first list shows Available classes which are not yet selected for the person, the second shows the classes that are selected for that person.

Also shows how to accomplish the same thing using a simple form and subform with a combo box for selecting the record.

Select Records97 Same as above, saved in  Access 97 format. Special thanks to MVP Douglas Steele who spotted a few conversion errors and graciously fixed them for me!
Multi Instance Forms
(version 1.0 - 5/13/2003)
Sample showing a way to open and manage multiple instances of a single form using a collection class. This example is very basic but the collection and member classes are reusable. The inline documentation is limited right now so feel free to contact me if you have specific questions.