Access.2007.VBA.Bibl..

Use the following lines to set a reference to a custom Contacts folder, creating it if necessary. If set- ting a reference to th ...

strWebSite = Nz(.WebPage) strNotes = Nz(.Body) .Close (olSave) End With With rst rst.AddNew ![CompanyName] = strCompanyName ![Fi ...

Else MsgBox “Error No: “ & Err.Number _ & “; Description: “ & Err.Description Resume ErrorHandlerExit End If End Fun ...

I n the previous chapters I discussed creating Word documents, Excel worksheets, and various types of Outlook items using VBA Au ...

object model) lets you pop up a dialog for selecting a file or a folder, with several dialog type options. This dialog lets user ...

FIGURE 9.1 A main menu with a Backup button and button/textbox controls for selecting an Input Documents path and an Output Docu ...

Else Debug.Print “User pressed Cancel” End If End With On Error Resume Next DoCmd.RunCommand acCmdSaveRecord ErrorHandlerExit: E ...

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

End Function Public Function GetOutputDocsPath() As String On Error GoTo ErrorHandler Set dbs = CurrentDb Set rst = dbs.OpenReco ...

FIGURE 9.2 Selecting a custom folder for storing documents in a database. FIGURE 9.3 Setting a reference to the Office 12.0 obje ...

The FileDialogobject has several useful methods and properties: n Filters.Add— Lets you specify the filter(s) for displaying fil ...

The FileSystemObject .............................................................................................. The FileSyst ...

Part II Writing VBA Code to Exchange Data between Office Components A Digression on Access Help I n my opinion, Access Help reac ...

Working with Files and Folders 9 A list of inappropriate Help topics on searching for “Tab control.” There is a Table of Content ...

Part II Writing VBA Code to Exchange Data between Office Components continued The Controls book in the Access Help Table of Cont ...

Working with Files and Folders 9 Using Google to get help for Access. There is another option for help, at least when you are wr ...

Part II Writing VBA Code to Exchange Data between Office Components continued Selecting an Access object in the Object Browser. ...

Backing up Your Database ................................................................................................ Everyb ...

FIGURE 9.7 The Access 2007 Back Up Database selection. FIGURE 9.8 The built-in database save dialog. If you are running the back ...

Though it is much easier to back up an Access database in Access 2007 than in previous versions, the new “Back Up Database” sele ...