Microsoft Access VBA Macro Programming

This provides a very easy way of making a sound, although it is very limited in what it can do. If you need more flexibility, se ...

screen resolutions, and what looks good on your development screen can look terrible on a user’s screen. Using this when a form ...

Action queries (such as delete, insert, or append) can be run in this way, but you can also use: CurrentDb.Execute "MyQuery" Ope ...

The parameters are all optional:  PrintRange An acPrintRange constant specifying the range to print—the default is acPrintAll. ...

If you turn the warnings off, make sure you switch them back on when your code has finished. This method has an effect throughou ...

The syntax is: DoCmd.TransferText (TransferType,SpecificationName,TableName,FileName,HasFieldNames, HTMLTableName,CodePage) Th ...

This page intentionally left blank ...

Chapter 17 Using Access to Interact with Other Office Programs Chapter 17 Using Access to Interact with Other Office Programs A ...

You can add a reference by selecting Tools | References from the menus. All available reference files will appear in a dialog. Y ...

oWdoc.SaveAs ("MyTest") oWdoc.Close oWd.Quit Set oWdoc = Nothing Set oWd = Nothing End Sub The first line declares the variables ...

Recently, I had the task of writing a program to populate an SLA (Service Level Agreement) Report. The SLA Report was a Word doc ...

Dim MoOutlook As Outlook.NameSpace Set MoOutlook = oOutlook.GetNamespace("MAPI") Set oFolder = MoOutlook.GetDefaultFolder(olFold ...

The first four lines set up variables based on the Microsoft Outlook types. These are for the Outlook application, the NameSpace ...

The example I am going to use writes to a table within an Access database from inside an Excel workbook. VBA works exactly the s ...

by using theCreateObjectmethod. This is exactly the same as if you had opened Access directly and chosen a blank database. Next, ...

PA RT III Advanced Techniques in Access VBA In this part, you’ll learn how to create charts and graphs in code, work with extern ...

This page intentionally left blank ...

CHAPTER 18 Charts and Graphs F rom Access 2007 onwards, creating and manipulating charts using VBA has become quite difficult an ...

Populate your table with some data. Your table should now look like Figure 18-2. You now need to create a template graph to be i ...

Finally, we get to the interesting bit of the VBA code to create a report, add a chart to it, and manipulate it with VBA. Insert ...