This example shows how to prevent a form from closing except by using a command button. The example is the main menu/switchboard form. Note that this technique can be easily used on any form.

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.

This is an update to the basic example of how to store the path to a file and also be able to view the file. You can browse using the standards windows common dialog to select the file. You can view the file using the application defined with the Windows File Associations. It uses the ShelExec API to open the file. It does not use the .Followhyperlink  method.

This example is a continuous form that could easily be used as a sub form to attach multiple documents to a record.

***** Because it doesn't use the hyperlink data type, this new version stores the path in a way that allows the folder to be easily moved. 

By Candace Tripp (utter:angel) Access 2000 format

Demonstrates a method of displaying a picture/image file in a database/formwithout storing the image in a table.

** Updated 1/9/2010 to handle an issue with Access 2010.

Authior: Unknown

I have been using this code since 1993 with Access 2.0. The download file includes the Access 2.0 version,. I have also included the upgraded versions for Access 97, Access 2000, and Access 2007. 

It has a Zoom Box, Calendar and Calculator created with just native Access controls. The pop up forms can be used to edit the data in as many  text box controls as needed. The controls can be on the same form or multiple forms.