Microsoft Access Programmers Minnesota

Microsoft Access Programmer Information

Call MS Access Solutions at (323) 285-0939 For Complimentary Consultation

Creating Custom Properties and Methods

Forms and reports are Class modules, which means they act as templates for objects you create instances of at runtime. Public procedures of a form and report become Custom properties and methods of the form object at runtime. Using VBA code, you can set the values of a form's Custom properties and execute its methods.

Creating Custom Properties

You can create Custom properties of a form or report in one of two ways:

1. Create Public variables in the form or report.

2. Create PropertyLet and PropertyGet routines.

Creating and Using a Public Variable as a Form Property

The following steps are used to create and access a Custom form or report property based on a Public variable. The example is included in CHAP10EX.ACCDB in the forms frmPublicProperties and frmChangePublicProperty.

1. Begin by creating the form that will contain the Custom property (Public variable).

2. Place a Public variable in the General Declarations section of the form or report.

3. Place code in the form or report that accesses the Public variable. The code in Figure 10.26 creates a Public variable called CustomCaption. The code behind the Click event of the cmdChangeCaption command button sets the form's (frmPublicProperties) Caption property equal to the value of the Public variable.

4. Create a form, report, or module that modifies the value of the Custom property. Figure 10.27 shows a form called frmChangePublicProperty.

5. Add the code that modifies the value of the Custom property. The code behind the ChangeCaption button, as shown in Figure 10.26, modifies the value of the Custom property called CustomCaption that's found on the frmPublicProperties form.

To test the Custom property created in the preceding example, run the frmPublicProperties form, which is in the CHAP10EX.MDB database on the sample code CD-ROM. Click the Change Form Caption command button. Nothing happens because the value of the Custom property hasn't been set. Open the frmChangePublicProperty form and click the Change Form Property command button. Return to frmPublicProperties and again click the Change Form Caption command button. The form's caption should now change.

This material orginally appeared in Alison Balter's book Mastering Microsoft Office Access 2007 Development. Reprinted here by author's permission.

When you need a Microsoft Access programmer for your Anaheim CA business, call MS Access Solutions at (323) 285-0939. We have over 25 years experience in Microsoft Access programmer solutions. We create Access database applications for all sectors, consisting of hospitals, government agencies, the U.S. military, universities, agriculture, workers services, and insurance provider. We can take care of the most advanced as well as complicated Access and also SQL Server database programming for your business as well as smaller projects, like fixing damaged Access database forms, MS Access reports, Access macros, and VBA code.

Access programmer cities we serve: Access Programmers Minneapolis Minnesota