Microsoft Access VBA Macro Programming

If a query you are going to use in VBA is complicated, encompassing several tables, it is a good idea to work it out first using ...

Also, it is important to put theMoveNextstatement in, otherwise your code will never finish and will just stay on the first reco ...

This again works as before, but theAddNewmethod is used to insert a new record. The fields within the recordset are provided wit ...

Notice that zero values have been inserted into each select statement so the number of columns in each select statement is the s ...

To run this from within VBA, you can use the DoCmd object (see Chapter 16 for more information on this object): Sub DeleteQuery( ...

This assumes that MyTable has a field called CutomerName. This will create a new table called MyNewTable, which only contains re ...

I have found that if problems occur, it is worth splitting the Append query into several small sections using criteria so as to ...

To run this from within VBA, you can use the DoCmd object (see Chapter 16 for more information on this object): Sub MakeTableQue ...

Because it does not return records, it is run as a command. In its simplest form, it appears as: UPDATE MyTable SET CustomerName ...

As said previously, do not forget to set the warnings back again. If you do not, you will receive no warnings at any point withi ...

If Asc(Mid(Target, n, 1 )) >= 97 Then CheckUpperCase = False Exit Function End If Next n CheckUpperCase = True End Function T ...

Chapter 13 Table Macros Chapter 13 Table Macros A new feature of Access 2010 is the ability to create table macros. These perfor ...

Save your table with the nametblTestTableMacro. Do not worry about defining a primary key. This is not required for this example ...

In the first “Add New Action” drop-down that appears, select SetField. Your design window will look like Figure 13-3. Chapter 13 ...

After selecting Set Field, you will see a design window for your particular action to set a field value. Enter the name of the f ...

If you need to edit your action, simply click the Set Field text in the action. This will bring you back to the design section. ...

What sort of uses could you put this to within your application? If you had a table that collected data to work out something li ...

Use the Create Record In option to select your second table (tblTableMacroCopy). Click the Add New Action field within the gray ...

This page intentionally left blank ...

PA RT II Object Models In this part, you will learn all about the various object models used in Access and how to use these with ...