Access.2007.VBA.Bibl..

The sample Northwind Plus database contains tables from the Northwind.mdb database, with sev-

eral extra fields in some tables, queries (used in the next section), and three new forms — two main

forms (one for selecting records for shipping and one for reordering depleted inventory) plus a

supplementary form for editing product amounts.

When opening Northwind Plus in Vista, you may get the security alert shown in Figure 12.1.

To temporarily enable the database’s code, click the “Enable Content” button and select the

“Enable this content” option in the dialog. To prevent this security alert from appearing every time you

open the database, sign the VBA code with a digital signature, as described in the sidebar.

FIGURE 12.1

A Vista security alert when opening a database with unsigned VBA code.

NOTENOTE

Part II Writing VBA Code to Exchange Data between Office Components

Creating a Digital Signature for

Signing Your Access VBA Code

1. On the Windows Vista Start menu, select All Programs.


2. Select the Microsoft Office folder.


3. Select the Microsoft Office Tools folder.