13.7. Touring the Finished Project Tracker Application

Now comes the fun part. You get to see the benefit of that hard work. Let's quickly look at each screen just to point out the most interesting features. You have already seen the screens in the design process, but it is always fun to see them working with real data in them.

You will have to click the Options button next to the security warning when you open the database and enable macros in the database, or none of the code you wrote will be allowed to execute.

For starters, Figure 13-28 illustrates a sample project record on the Project Tracker screen. It shows details about this sample Project Tracking project and also comments that have been entered into the list on the first tab.

Figure 13.28. Figure 13-28

Figure 13-29 shows some contacts for the current project. You can view information such as name, phone numbers, and e-mail address. If you click the e-mail button, you will see a screen similar to that shown in Figure 13-30 with the e-mail address of the selected contact already filled in. The capability to integrate e-mail into your applications is really slick and will impress many users. You can also consult Chapter 7 on exporting and Chapter 10 on automation for more information on e-mail integration, for example, through Outlook.

Figure 13.29. Figure 13-29

On the other hand, if you select the View Details for ...

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.