Microsoft Access Database Programmer Fresno 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 Fresno 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.

Object Variables Versus Regular Variables

The difference between object variables and regular variables is illustrated by the following code:

Dim intVar1 As Integer

Dim intVar2 As Integer

intVar1 = 5

intVar2 = intVar1

intVar1 = 10

Debug.Print intVar1 'Prints 10

Debug.Print intVar2 'Prints 5

This code uses ordinary variables. When you dimension these variables, each one is assigned a separate memory location. Although intVar2 is initially assigned the value of intVar1, changing the value of intVar1 has no effect on intVar2. This differs from the following code, which uses an object variable:

Private Sub Command5_Click()

Dim ctlText As TextBox

Set ctlText = Forms.frmSales.txtProductID

ctlText.Text = "New Text"

Debug.Print Forms.frmSales.txtProductID.Text 'Prints New Text

End Sub

This routine creates an object variable called ctlText of type TextBox. It then associates the object variable with Forms.frmSales.txtProductID. Next, it modifies the Text property of the object variable. Because the object variable is actually pointing to the text box on the form, the Debug.Print statement prints the new text value.

Generic Versus Specific Object Variables

Access supports the use of generic object variables, including Application, Control, Form, and Report. Generic object variables can be used to refer to any object of that generic type:

Private Sub ChangeVisible_Click()

Dim ctlAny As Control

Set ctlAny = Me.txtCustomerID

ctlAny.Visible = False

End Sub

In this example, ctlAny can be used to point to any control. Compare that to the following code:

Private Sub cmdChangeVisible_Click()

Dim txtAny As TextBox

Set txtAny = Me.txtCustomerID

txtAny.Visible = False

End Sub

Here, your object variable can be used only to point to a text box.

Cleaning Up After Yourself

When you're finished working with an object variable, you should set its value to Nothing. As used in the following example, this statement frees up all memory and system resources associated with the object:

Set frmNew = Nothing

Access Programmer for Fresno 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 Fresno 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 Glendale CA.