Microsoft Access Database Programmer Greensboro NC

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 Greensboro NC 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.

Manipulating a Collection of Objects

A collection is like an array of objects. What makes the array special is that it's defined and maintained by Access. Every collection in Microsoft Access is an object, each with its own properties and methods. The VBA language makes it easy for you to manipulate Access's collections of objects; you simply use the For Each...Next construct, which performs the same command on multiple objects.

In the "Determining the Type of a Control" section later in this chapter, you learn how to loop through the collection of controls on a form, performing actions on all the command buttons. This illustrates a practical use of a collection. In the following example, you loop through all the open forms, changing the caption of each form:

Sub FormCaptions()

Dim frm As Form

For Each frm In Forms

frm.Caption = frm.Caption & " - " & CurrentUser

Next frm

End Sub

This routine uses the For Each…Next construct to loop through each form in the Forms collection, setting the caption of each form to the form's caption concatenated with the current username. As you travel through the loop, the code frm.Caption refers to each member of the Forms collection.

Passing Objects to Subroutines and Functions

Just as you can pass a string or a number to a subroutine or function, you can also pass an object to a subroutine or function. The code, found in the basExamples module in the Chap9Ex database, looks like this:

Sub ChangeCaption(frmAny as Form)

'Change the caption property of the form received

'to what was already in the caption property,

'concatenated with a colon and the name of the current user

frmAny.Caption = frmAny.Caption & ": " & CurrentUser

End Sub

The ChangeCaption routine receives a reference to a form as a parameter. The caption of the form referenced by the procedure is modified to include the name of the current user. The ChangeCaption routine is called like this:

Private Sub cmdChangeCaption_Click()

'Call the ChangeCaption routine, passing a reference to the current form

Call ChangeCaption(Me)

End Sub

In this example, the click event of the cmdChangeCaption command button calls the ChangeCaption routine, sending a reference to the form that the command button is contained within. You will find this code in the frmChangeCaption form.

Access Programmer for Greensboro NC 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 Greensboro NC 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 Hartford Connecticut.