Access VBA Macro Programming

Weekday TheWeekdayfunction returns an integer between 1 (Sunday) and 7 (Saturday) that represents the day of the week for a date ...

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

All the applications in the Microsoft Office Suite support OLE automation in that you can load in a reference to a particular ob ...

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

The other command to use before you send keys isAppActivate. If the application is already loaded, you do not need to use theShe ...

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

Chapter 5: Strings, Functions, and Message Boxes 65 Key Code BACKSPACE {BACKSPACE}, {BS}, or {BKSP} BREAK {BREAK} CAPS LOCK {CAP ...

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

To specify that any combination ofSHIFT,CTRL, andALTshould be held down while several other keys are pressed, enclose the code f ...

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

to thetypeparameter, you get a nice list box showing all your options. Four icons can be used, depending on circumstances, as sh ...

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

Following is an example of the message box with Yes and No buttons and a defined caption: MsgBox "Test message", vbYesNo, "My me ...

This page intentionally left blank ...

This example will show a two-button message box (Yes and No). If Yes is clicked, the following message box will show 6 (vbYes). ...

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

This page intentionally left blank ...

CurrentDb CurrentDbis a top-level DAO (Data Access Objects) object. It allows you to create recordsets and use your VBA code to ...

Chapter 6 Operators Chapter 6 Operators O perators perform mathematical functions, comparison functions, or logical operations b ...

MyField must be a numeric value. The method will return the average of all the MyField values within the table. You can use an o ...