Microsoft Access Database Programmer Albuquerque NM

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 Albuquerque NM 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.

Private Procedures

As mentioned, all user-defined procedures are automatically public. If you want a procedure declared in a module to have the scope of that module only, meaning that you can call it only from another routine within the module, you must explicitly declare it as private.

The procedure shown in Figure 8.9, called IAmPrivate, is private. You can call it only from other procedures in the Standard basUtils module.

Scope Precedence

Private procedures always take precedence over public procedures. If a private procedure in one module has the same name as a public procedure declared in another module, the private procedure's code is executed if it's called by any routine in the module where it was declared. Naming conflicts don't occur between public and private procedures (unless you declare a public and private variable with the same name in the same module).

TIP

Developers often wonder where to place code: in Form or Report Class modules, or in Standard modules? There are pros and cons to each method. Placing code in Standard modules means that you can easily call the code from anywhere in your application, without loading a specific form or report. Public routines placed in Standard modules can also be called from other databases. For this reason, Standard modules are a great place to put generic routines that you want readily available as part of a library.

Access 2000, Access 2002, Access 2003, and Access 2007 load modules on a demand-only basis, which means that procedures no longer take up memory unless they're being used. This is especially true if you plan your modules carefully. Regardless of when Access loads the code, an advantage of placing code behind forms and reports (rather than within modules) is that the form or report is self-contained and, therefore, portable. You can import the form or report into any other database, and it still operates as expected. This objectoriented approach means that the form requires nothing from the outside world.

As you can see, there are pluses and minuses to each method. As a general rule, if a routine is specific to a particular form or report, place that routine in the form or report; if it's widely used, place it in a module.

Access Programmer for Albuquerque NM 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 Albuquerque NM 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 Anaheim CA.