13.3. Building the User Interface

Now that the tables have been created, it's time to move on to creating the empty forms for the user interface. You can then write the code in class modules and standard modules, and finish off by adding code to each form to call the class modules and standard modules. The example in this chapter uses ADO to connect to the ProjectTrackerDb database, but you can alternatively or additionally add an explicit link to the separate database so you can see the tables from within your user interface project.

Try It Out: Building the frmProjects and frmContacts Forms

Now let's create the separate database file that will store the user interface objects:

  1. Select the Office Button New. From the list of available templates, select "Blank Database" and specify ProjectTrackerUI for the file name. Click the Create button.

  2. Create a new form called frmProjects. First, open the form in design view. From the ToolBox, double-click the tab control and size it appropriately on the form. Select the tab control and right-click, so you can insert a third tab if one is not already present by using the Insert Page option. You add additional tabs/pages as illustrated in Figure 13-13.

  3. Next, drag and drop the numerous other controls onto the form and page 1 of the tab, as shown in Figure 13-14.

    Figure 13.13. Figure 13-13
    Figure 13.14. Figure 13-14
  4. The following table will ...

Get Beginning Access™ 2007 VBA now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.