Microsoft Access VBA Macro Programming

If there is no disk in drive D, the code will still run perfectly because ofOn Error Resume Next—it skips over the line of code ...

You can generate an error in your code with theErrorstatement: Sub Test_Error() Error 71 End Sub This simulates the “Drive not r ...

This page intentionally left blank ...

Chapter 9 Forms and Reports Chapter 9 Forms and Reports F orms and reports are the means by which your application interfaces to ...

Creating a Simple Form To create a form, click the Create tab in the ribbon and then click the Form Design icon in the Forms gro ...

To display your form, click the Design tab in the ribbon and then click the Form View icon in the Views group of the ribbon. You ...

soon as the user moves to another record or closes the form, that change is saved back to the underlying tables and there is no ...

In order to display the name of an employee instead of the ID number, you could make the record source of your form a query join ...

This is a standard SQL select statement. Notice that first name and last name are concatenated together using a space in the mid ...

onto your form. Change its Control Source to Quantity. Set the corresponding label control caption to read Quantity. Add three t ...

Open the Order Details subform in Design View. Set the Default View property to Datasheet View. Look at the form in Datasheet Vi ...

However, when the record source has many records, this can become tedious. If the form is displayed as a datasheet view, it will ...

The Allow Datasheet View property on the form must be set to Yes for this view to be available. Datasheet views are often used i ...

View the form in Design View. Select all the controls you want to set to a uniform size and alignment by dragging a box across t ...

Other Controls Many other controls can be used on a form, but the following are the main ones. Button The Command button control ...

with some very nice icons on them, such as Close Form, and if you choose the wizard approach, you do not even have to write the ...

Option Buttons Option buttons are sometimes known as radio buttons because as you click one in a group of option buttons, the ot ...

Using VBA on Forms Up till now, this chapter has looked at how to build forms and bind the controls to the underlying data. Alth ...

You can view the events by right-clicking the form in Design mode and then clicking Build Event in the pop-up. Click Code Builde ...

You may want to use the After Insert event to create a child record in another table that is related to the new record being cre ...