Microsoft Access Database Programmer Oakland CA

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 Oakland CA 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 Custom Methods

Custom methods are simply Public functions and subroutines placed in a Form module or a Report module. As you will see, they can be called by using the Object.Method syntax. Here are the steps involved in creating a Custom method; they are found in CHAP10EX.ACCDB in the forms frmMethods and frmExecuteMethod:

1. Open the form or report that will contain the Custom method.

2. Create a Public function or subroutine.

3. Open the Form module, Report module, or Code module that executes the Custom method.

4. Use the Object.Method syntax to invoke the Custom method.

Practical Examples: Applying Advanced Techniques to Your Application

You can use many examples in this chapter in all the applications that you build. To polish your application, build a startup form that displays a splash screen and then performs some setup functions. The CHAP10EX.ACCDB file contains these examples.

Getting Things Going with a Startup Form

The frmSwitchboard form is responsible both for displaying the splash screen and for performing the necessary setup code.

The Form_Load event first invokes an hourglass. It then opens the frmSplash form. Next, it calls the GetCompanyInfo routine to fill in the CompanyInfo type structure that is eventually used throughout the application. (Type structures are covered in Chapter 13, "Advanced VBA Techniques.") Finally, Form_Load turns off the hourglass.

Summary

Forms are the centerpiece of most Access applications, so it's vital that you are able to fully harness their power and flexibility. This chapter showed you how to work with Form and Control events. You saw many examples illustrating when and how to leverage the event routines associated with forms and specific controls. You also learned about the types of forms available, their uses in your applications, and how you can build them. Finally, you learned several power techniques that will help you develop complex forms.

Access Programmer for Oakland CA 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 Oakland 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 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 Oklahoma City OK.