Access.2007.VBA.Bibl..

rst.CursorType = adOpenStatic, “Static (“ _ & adOpenStatic & “)”) strLockType = Switch(rst.LockType = _ adLockOptimistic ...

ErrorHandler: MsgBox “Error No: “ & Err.Number _ & “; Description: “ & Err.Description Resume ErrorHandlerExit End S ...

TABLE 5.6 (continued) Cursor Type Named Constant Lock Type Named Constant Available Methods adOpenStatic AdLockOptimistic AddNew ...

Private Sub TestKeysetOptimistic() On Error GoTo ErrorHandler Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Dim strCate ...

& Chr$(39) & “ already used; “ _ & “please enter another category “ _ & “name” strTitle = “Category used” MsgBox ...

The code prints the search string (always useful for debugging) and the number of records in the recordset, before and after add ...

Attempt to find the database, and put up a message if it is not found. Set fil = fso.GetFile(strDBNameAndPath) If fil Is Nothing ...

& vbCrLf & vbTab & “City: “ & ![City] _ & vbCrLf rst.MoveNext Loop End With ErrorHandlerExit: Close the Reco ...

It is the default cursor type. For the fastest access to data that you don’t need to modify, use a forward-only cursor and the a ...

Set cnn = Nothing End If End If Exit Sub ErrorHandler: MsgBox “Error No: “ & Err.Number _ & “; Description: “ & Err. ...

You can’t exchange data between ADO and DAO recordsets, even when working in databases with references set to both object models ...

Create a connection to an external database. strDBName = “D:\Documents\Northwind.mdb” Set cnn = New ADODB.Connection Set rst = N ...

...

D espite the new and improved report interactive features discussed in the “Report Layout View” sidebar, for full control over t ...

Part II Writing VBA Code to Exchange Data between Office Components Report Layout View Access 2007 reports have a new view selec ...

Built-in Word Export in Office 2007 ................................................................................ For many Of ...

The Word (RTF) and Word Mail Merge features in Access 2007 work much the same as in earlier Office versions. If you select an Ac ...

FIGURE 6.3 The Word RTF Export dialog when exporting an Access table. FIGURE 6.4 A Word document created by exporting an Access ...

The Word Mail Merge option runs a wizard, which is generally similar to the one in the last two Office versions. It offers you a ...

ErrorHandler: If Err = 429 Then ‘Word is not running; open Word with CreateObject Set appWord = CreateObject(Class:=”Word.Applic ...