Access VBA Macro Programming

TDef.Indexes.Append Idx End Sub This code sets up the relevant objects using theDimstatement. Note that you must create a databa ...

This page intentionally left blank ...

Chapter 32 Create an Objects Inventory Chapter 32 Create an Objects Inventory A ccess applications can become extremely complex ...

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

You can now add the following code into a module: Sub Inventory() Dim Obj As AccessObject, Dbs As Object, RecSet As Recordset Cu ...

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

Next Obj For Each Obj In CurrentProject.AllMacros RecSet.AddNew RecSet!ObjectName = Obj.Name RecSet!ObjectType = "Macro" RecSet! ...

This page intentionally left blank ...

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

If RecSet![First Name] = "Nancy" Then RecSet.Edit RecSet![Company] = "Northwind" RecSet.Update End If RecSet.MoveNext Loop If Ms ...

This will return the value of MyField for the last record in the table MyTable. You can use an optional criterion as follows: Ms ...

Chapter 33 Manipulate Chart Colors Chapter 33 Manipulate Chart Colors W hen using charts within your application, you will often ...

This will return the sum of all MyField values in the table MyTable. MyField must be a numeric data type. You can use an optiona ...

Save the table astblCurrency. On your blank form, drag a chart object onto the form. Make your currency table the row source for ...

Printer Printerwill allow you access to the default printer properties. You can view the name of the default printer using the f ...

Using theDimstatement, this code sets up an object for the chart and two variables. The chart object is set to point to the char ...

This will display the name of each report loaded, but notice that it does not include reports that are not loaded. You can addre ...

This page intentionally left blank ...

Version Versionwill tell you the version of Access that is being run. This is useful to know when the user loads your applicatio ...

Chapter 34 Drill Down on Charts Chapter 34 Drill Down on Charts R ecently, I was involved in an Excel application that allowed t ...