Microsoft Access Database Programmer Birmingham AL

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 Birmingham AL 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.

For...Next

The For...Next construct is used when you have an exact number of iterations you want to perform. It looks like this and is found under the For...Next command button of the frmControlStructures form:

Sub cmdForNext_Click()

Dim intCounter As Integer

For intCounter = 1 To 5

Me.txtAge.Value = Nz(Me.txtAge.Value) + 1

Next intCounter

End Sub

Note that intCounter is self-incrementing. The start value and the stop value can both be variables. A For...Next construct can also be given a step value, as shown in the following. (The counter is incremented by the value of Step each time the loop is processed.)

Sub ForNextStep()

' Note that this code is not in database Chap8ex.mdb

Dim intCounter As Integer

For intCounter = 1 To 5 Step 2

Me.txtAge.Value = Nz(Me.txtAge.Value) + 1

Next intCounter

End Sub

With...End With

The With...End With statement executes a series of statements on a single object or userdefined type. Here's an example (found under the With...End With command button of the frmControlStructures form:

Private Sub cmdWithEndWith_Click()

With Me.txtAge

.BackColor = 16777088

.ForeColor = 16711680

.Value = "Hello World"

.FontName = "Arial"

End With

End Sub

This code performs four operations on the txtAge text box, found on the form it's run on. The code modifies the BackColor, ForeColor, Value, and FontName properties of the txtAge text box.

TIP

The With...End With statement offers two main benefits. The first is simply less typing: You don't need to repeat the object name for each action you want to perform on the object. The more important benefit involves performance. Because the object is referred to once rather than multiple times, this code runs much more efficiently. The benefits are even more pronounced when the With…End With construct is found in a loop.

Access Programmer for Birmingham AL 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 Birmingham AL 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 Boise ID.