Microsoft® Office Access 2003 Step by Step

Using VBA to Create a Web Page

Exporting an Access object to static Web pages is quick and easy, but if you want to manipulate the data as you create the static pages, the export process won’t be of much use. A better way is to create a module containing VBA code that manipulates the data.

As an example, suppose The Garden Company wants to use data in the Customers table to create a set of 26 Web pages, one for each letter of the alphabet. Each page will list the customers whose last names start with the correlating letter and will contain links to all the other pages in the set. All the legwork for setting up the pages can be done with VBA code.

The sample GardenCo database for this exercise includes HTML_final, a finished and fully commented version ...