Access VBA Macro Programming

Contents at a Glance ...

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

This page intentionally left blank ...

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

Contents Acknowledgments..................................... xxi Introduction........................................ xxiii ...

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

...

Timer The Timer event is useful if you want to run a procedure at a fixed time interval, such as re-querying the form so that th ...

...

On the opening screen of the wizard, select your new query on the drop-down. You should have four possible fields showing (Ship ...

...

Keeping Your Report Tidy The wizard has produced for you a pristine looking report, but users will often later make requests tha ...