Microsoft Access Database Programmer New Orleans LA

Microsoft Access Programmer Information

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

The following material is shared here to indicate our commitment to professional Microsoft Access programmer services in the New Orleans LA area. Access programming for business is highly complex and requires dedication and skill to create a high quality database application. We wrote the book on Microsoft Access prgramming, so you know you will get the best possible Access database solution for your business.

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.

Close the frmPublicProperties form and try clicking the Change Form Property command button. A runtime error occurs, indicating that the form you're referring to is not open. You can eliminate the error by placing the following code in the Click event of cmdPublicFormProperty.

Access Programmer for New Orleans LA Attribution

This material originally 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 New Orleans LA 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 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.

More Access programmer cities we serve: Access Database Programmer New York NY.