Microsoft Access VBA Macro Programming

This page intentionally left blank ...

CHAPTER 14 The Access Object Models T he Access object models are at the heart of using VBA in Access. They distinguish programm ...

Using the object models and a programming language such as Visual Basic, it’s not difficult to develop your own Access front end ...

TheFormsobject has aCountproperty that defines how many forms are open in the Access application. The properties hold the parame ...

Of course, many other properties exist, but this gives you an idea of what some properties look like. Examples of object methods ...

To see an example of this, open or create a new report (the example assumes this has been saved with the name MyReport). While i ...

Calling Methods As explained earlier, methods effectively are subroutines based on objects that take certain actions, sometimes ...

function that has ten possible parameters even if you want to use only two of them. Consider the following example for importing ...

In Access, all objects are either singular objects referenced by name or objects in a collection referenced by index or name. Co ...

Initially, this code sets up a variablewto represent aTableDefobject. This represents the current table definition being cycled ...

the Object Browser for this information because it can be difficult to know what command to use next. It is also easy to make mi ...

By default, the Object Browser references two separate object models. This is Access and DAO. The Access object model references ...

show the property type and if it is read-only. Clicking a method displays the syntax for parameters and which ones are optional ...

Notice the statements to get the field data. An exclamation mark (!) is used instead of a dot (.) because the field names are no ...

RecSet.AddNew RecSet!Company = "MyCompany" RecSet![Last Name] = "Shepherd" RecSet![First Name] = "Richard" RecSet.Update RecSet. ...

Set WrkSp = DBEngine.Workspaces( 0 ) WrkSp.BeginTrans Do Until RecSet.EOF If RecSet![First Name] = "Nancy" Then RecSet.Edit RecS ...

automatic list boxes and providing a full hierarchy in every line of code. This example works with the Northwind database Employ ...

does not have properties and methods (commands) that apply to theTableDefobject or the CurrentDbobject. You cannot use aFieldobj ...

This page intentionally left blank ...

Chapter 15 The Main Objects Chapter 15 The Main Objects I n the preceding chapter, we looked at the object models in terms of ho ...