Access VBA Macro Programming

then you can use a message box to ask the user for a confirmation to save. If the user answers No, then the code uses the Undo m ...

in scope (meaning it is used within the procedure you are running), and it will give you the value of it instantly. You can also ...

This code initially creates aTableDefobject using theDimstatement. It then uses the CreateTableDefmethod to create a new table c ...

You can restart your code by clicking the Run symbol on the toolbar (the triangle symbol pointing to the right) or pressingF5; i ...

QueryDefs TheQueryDefscollection represents all the query definitions within the database. You can iterate through this collecti ...

You can insert a breakpoint where you want to start checking the code and then single-step the procedure to see what each statem ...

Main Properties, Methods, and Collections This section details the main properties, methods, and collections you will use within ...

The earliest active procedure call is shown at the top of the list, and any subsequent procedure calls are added to the top, as ...

Edit TheEditmethod is used to edit records in theRecordsetobject. It allows changes to be made to data in specified fields. TheU ...

You can set the Debug window, as shown in Figure 7-3, by using Debug | Add Watch from the menu. Enter the variable or expression ...

FindLast TheFindLastmethod uses a specified criterion to find the last instance of a record within the recordset. The recordset ...

Events That Can Cause Problems When Debugging Certain events in windows can pose problems for the debugger by complicating and c ...

MoveFirst TheMoveFirstmethod selects the first record in the recordset. RecSet.MoveFirst MoveLast TheMoveLastmethod selects the ...

Got Focus / Lost Focus A got focus / lost focus event occurs when a user clicks your form or a particular control on the form to ...

This page intentionally left blank ...

You can change the caption properties on aUserFormobject using code. This assumes you have already definedUserForm1and that it i ...

Chapter 16 The DoCmd Object Chapter 16 The DoCmd Object T heDoCmdobject is a special object model in Access VBA. It is fairly si ...

Chapter 8 Errors and the Error Function Chapter 8 Errors and the Error Function R untime errors can creep into code very easily, ...

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

Try this simple examplewithouta disk in drive D. Place the code into a code module and then run it by pressingF5: Sub Test_Error ...