Database Design - Appendix B: Command Buttons

Each button calls a subroutine of that name. The design view of button 1 (Create a table) is shown in figure B-2.

Screen Shot of the design view of the "SQL setup" form. The graphic highlights the event handling properties of the "Create _Table" command buttton. The event handling property "On Click" is shown set to [Event Procedure]: this will invoke the Create_table_Click() subroutne each time the user clicks on that button.

Figure B-2: Design view showing the event handling properties of the command button create_table

Each command button is named as follows:

create a table (Rooms) create table
add room 1 to rooms add room 1
add more data add more data
update record 5 update record 5
delete record 6 Delete record 6

The Event Procedures are automatically named by Access as follows:

create_table_Click()
add_room_1_Click()
add_more_data_Click()
update_record_5_Click()
Delete_record_6_Click()

The code assigned to each of these command buttons is shown in the following screens.

Database Design: Appendix B - Command Buttons